Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
INDEX
I am using Excel 97. I am wanting a userform to look at a
table on a worksheet and give the mileage result between two locations. The code I have used (which doesn't work) is: Me.txtNONTAXABLE1 = Application.Index(Worksheets ("Mileage Chart").Range("b2:bd56"), Me.comboFrom1, Me.comboTo1) I've also tried: Me.txtNONTAXABLE1 = Application.WorksheetFunction.Index (Worksheets("Mileage Chart").Range("b2:bd56"), Me.comboFrom1, Me.comboTo1) So that the value of the textbox on the userform changes if the combo boxes on the userform are changed. Can anyone put me on the right track, please? Thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX | Excel Discussion (Misc queries) | |||
Index and #NA | Excel Discussion (Misc queries) | |||
Should I use INDEX? | Excel Discussion (Misc queries) | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) |