Hi,
I'm not very good (at all with userforms).
I have a spreadsheet with names in A:A (variable number of names). Each name has a corresponding data point in B and C.
I would like to run a macro that opens up a userform with a drop down list of each name in A:A. Once a name is selected, press OK on the same userform. This will then run the rest of my macro which will use selectedName, dataPointB and dataCointC as variables. I would like to 'capture' the name and corresponding variables - I think this might be doable with a scripting.dictionary approach but I'm not sure if that's best (simple offset might be better after getting cell reference of name selection?)
Thanks
I'm not very good (at all with userforms).
I have a spreadsheet with names in A:A (variable number of names). Each name has a corresponding data point in B and C.
I would like to run a macro that opens up a userform with a drop down list of each name in A:A. Once a name is selected, press OK on the same userform. This will then run the rest of my macro which will use selectedName, dataPointB and dataCointC as variables. I would like to 'capture' the name and corresponding variables - I think this might be doable with a scripting.dictionary approach but I'm not sure if that's best (simple offset might be better after getting cell reference of name selection?)
Thanks