Loading userform

Hey

Please Login or Register  to view this content.

The form loads when i double click... however it only works in column A. When i do it in anyother column an error appears... anyone have any ideas why?

Thanks

Hello Tian0020,

I ran a abbreviated form of your routine using this macro with no problems.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi

Problem related to the activecell.offset(0,1).value not being a valid entry for cboRegion, based on the rowsource property.


rylo