Jump to content
Sign in to follow this  
Ram

Excel to ComboBox

Recommended Posts

Ram

Hi,

I have an interface that has combo box with all the 50 US STATES. I have the same 50states in an excel file.

Now I would like select the states in combo box accroding to the excel file column but I can't do it.

This is what I tried. I put a for loop and called this:

ControlFocus ("E", "", "ComboBox1")

ControlSetText ("E", "", $Columna[$i])

Msgbox (0, "State", $Columna[$i])

the above didn't do anything.

and I tried

ControlFocus ("E", "", "ComboBox1")

ControlSend ("E", "", $Columna[$i])

Msgbox (0, "State", $Columna[$i])

This just sends all states that are in the excel file.

Can you help me out in choosing the states in the combobox according to file?

Awaiting your response!

Thanks !

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.