I have created a block with a number of attributes but when I insert this block into a drawing the order in which I am prompted to complete the attributes is confusing.
Is there a method of changing the order in which I am prompted for this data?
Thanks
Thanks for the speedy reply.
Its a sheet that will be used by others in the company so i want to make it as simple to look at and understand as possible so i want to avoid unnecessary columns if i can.
I could always hide the surrogate column but is there a more elegant solution that anybody...
I have a sheet that performs calculations on a series of data and then uses the MAX function to identify the highest result.
My problem is that in the range of data in which im trying to find the max I have cells containing #value and #ref. Is there any way that i canignore (or treat as zero)...
Have you tried starting the macro recorder and then opening the file and modifying the code. Ive done this previously when my text file has been comma delimited and extracted the following code
Workbooks.OpenText sfilename, DataType:=xlDelimited, Comma:=True, FieldInfo:=Array(Array(1...
If you know the file you wish to open you can use
Workbboks.OpenText sFilename
where sFilename is the full path and file name of the path to open
If you dont know the name of the file to open put the following line of code before the Workbooks.opentext line
sFilename =...
I have a range of data but within this range there are some empty cells, some cells containing text and others with numbers. How can I find the first empty cell within each column? Say my data was in range A1:B25 wth cells A3 and B15 empty I want cell A26 to display 3 and B26 to display 15.
I...
CajunCenturion :
My language options in control panel is set dd/mm/yyyy
Timberframe :
I am on 2003. I have a sheet with about 20000 rows so doing each cell manually would take me for ever and this is an activity i need to do regularly. Also as the format isnt consistent within each column i...
I have a list of data in excel with the data arranged in rows, the data is a mix of text, numbers and dates. When i open the file and examine the data everything is fine.
Now the problem ... I want to move this worksheet on to a new sheet in an existing workbook, i use the edit >>>> move/copy...
In your combobox change the additems to "Steel" etc
Then in the commandbutton1_click procedure use the select...case statement to set your value
Select Case ComboBox1.Value
Case "Steel"
numerical_value = 7.85
Case "Aluminium"
numerical_value = "2.60"...
I am trying to open a new file within excel when running a macro. The file to open will have a different name each time so i require the user to input the filename. The file will always be a comma separated text file. I need the file to open in excel without having to go through the text import...
correction to above post
As the listindex returns 0 for item at top of list but your original data only starts at row 2, the code should read
row_number = ListBox1.ListIndex + 2
Firstly you need to find which row the result of your listbox is in.
If the data in the listbox is the same order as the data on your sheet you can use the listindex property. This would return 0 if the first item in the list is selected, 1 if the second item is selected and so on. Then a line...
At the moment the clicking of the buttons doesnt run any code. You need some code in the sub commandbutton1_click(), something like
Sheets("sheet1").Cells(8, 1).Value = ListBox1.Value
