Search results

Jack I tried a way around. But Again a minor error in code. I am trying to gather and group instrument data. Kindly take a look at the code below. Sub Grouping_inst() Dim boxes As Integer, m As Integer, i As Integer, msg As String boxes = InputBox("How many Instrument groups are...

Hi all I am trying to display the selection made by the user in the list box. Its a Multi Selection List Box. I am trying to display to the user that he/she had selected this, this etc, depending on his/her selection in the list. The following code displays the selection individually. Can you...

Thanks Doc for your reply. But I am using a 2D Graph and I got this code randomly thru the net, and when I use it on my chart, I get two answers. I don't know why? Ram P

Hi Xlers I am trying to get the chart height using the following codes. MsgBox ActiveChart.PlotArea.Height MsgBox ActiveChart.PlotArea.InsideHeight. I get two different answers to the above. I am confused. What is the difference between Height and Inside height for a Chart? Thanks for your...

Thanks a lot for your help. I was able to increase the font size on My desktop. I want it to be common on it. Thanks once again. Ram P

Hi A simple doubt w.r.t Message Boxes and Input Boxes. Can we increase the Font Size, Style etc of the Message / Input Box text? If yes, Can you tell me how? I am getting short sighted by having to look close into the screen to understand what the message / input box says. Thanks a lot for...

Thanks a lot for your help. Got confused.. Ram P

Hi I am trying to extact the file name and use it as a variable in Xl. I am importing a text file in here and since it is a text file, the sheet shall have the same name as the imported text file. It is then saved as the same name with .xls extension. What I am trying to do is to extract the...