blckngldhwk
Technical User
I have a macro that is programmed to open up a web based form. Within that form is a drop down box with several options. Without the macro, when you select an option within that box with the mouse, the form will generate specific information based on what you have selected. My problem is, I have the macro programmed, I have it set up to select the correct value within the dropdown box but the form doesn't recognize that value as having been 'selected'...if that makes sense.
Below is an example of the code...
...
...
This works great in that it will make the value of the dropdown box show as "90378 - Synagis" but the form isn't recognizing that this is an active selection unless you go in and actually select the option.
Does this make sense? How can I get the macro to mimic the actual mouse selection of the option?
Below is an example of the code...
...
Code:
If JCode = "90378" then
objIE.Document.All("jcode").Value = "90378 - Synagis"This works great in that it will make the value of the dropdown box show as "90378 - Synagis" but the form isn't recognizing that this is an active selection unless you go in and actually select the option.
Does this make sense? How can I get the macro to mimic the actual mouse selection of the option?