UserForm - ComboBox - Row Source

[Josh_123456]

I am trying to create a row source of the 50 states

instead of using a sheet

is there anyway to create a module with them

I have about 7 forms that have a combo box where they choose a state

so on form initialize

can i call another procedure

cbxState.rowsource = (call procedure with states)


thank you

Josh

[raypayette]

It seems that you are creating ComboBoxes on worksheets. You could have only one in a UserForm that would tansfer its result to any worksheet!