Sign in to follow this  
Followers 0
Ram

Excel to ComboBox

2 posts in this topic

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  
Followers 0