Jump to content
Macro Express Forums

drop down menu and excel


Recommended Posts

I am working on a macro to choose from a drop down menu in a form in firefox based on an MS Excel cell entry?

 

For example if the excel cell said "MACRO" : it will choose the drop down option "MACRO"

and so on..

 

can someone point me to the right function I should be using for this?

 

Thanks!

 

N.

Link to comment
Share on other sites

In IE 8 you could simply type "Marco". Not sure about FF. I know older versions of IE will only allow the first letter to be used. For instance in a list of states you could type "mon" to get "Montana" in IE8 but in IE6 it will first highlight "Maine" then jump to "Ohio".

 

Do you know the list contents ahead of time? You could just arrow down a certain number of times based on the selection.

 

Also it there any reason you're driving this from Excel? It might be better to drive it from lists managed with MEP.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...