Solved

select radio button in webbrowser control using vba

Posted on 2015-01-31
8
361 Views
Last Modified: 2015-01-31
I have a webpage with the following code:
<label><input type="radio" name="patient_gender" value="patient_gender_m" id="patient_gender_value_patient_gender_m" />Male</label>
<label><input type="radio" name="patient_gender" value="patient_gender_f" id="patient_gender_value_patient_gender_f" />Female</label>

Open in new window

I would like to select the male or female radio button as appropriate.

What is the correct code to do this?

I have successfully filled input boxes on the page with code like:
Me.ocxWebBrowser.Document.Forms(0).patient_fname.Value = "Nelson"

Open in new window


These create the error "object doesn't support the property:
Me.ocxWebBrowser.Document.Forms(0).patient_gender_value_patient_gender_m.checked=true
Me.ocxWebBrowser.Document.Forms(0).patient_gender_value_patient_gender_m.click

Open in new window

0
Comment
Question by:thenelson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40582141
Instead of true/false, try check / uncheck.

i am looking for exact syntax now.
0
 
LVL 39

Author Comment

by:thenelson
ID: 40582145
Me.ocxWebBrowser.Document.All.patient_gender_value_patient_gender_m.checked=check
produces "object doesn't support this property"
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40582148
I was hopping this will work:

Me.ocxWebBrowser.Document.All.patient_gender_value_patient_gender_m.checked

with no = True
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 39

Author Comment

by:thenelson
ID: 40582151
Me.ocxWebBrowser.Document.All.patient_gender_value_patient_gender_m.checked
produces "object doesn't support this property"

not sure what you mean by:
with no = True
0
 
LVL 39

Author Comment

by:thenelson
ID: 40582161
I found my problem. The correct syntax is:
       Me.ocxWebBrowser.Document.Forms(0).patient_gender_value_patient_gender_m.Click
but the webpage I am trying to interface with changes the name of the gender radio button depending upon which form is called up. I some cases it is:
     patient_gender_value_patient_gender_m
while other forms (for the same page), its:
     gender_value_gender_m

The other field id's remain the same between the forms.
0
 
LVL 34

Accepted Solution

by:
Mike Eghtebas earned 500 total points
ID: 40582162
In c# and vb.net, in code behind for asp.net project, the object like patient_gender_value_patient_gender_m will have a method checked(). This way you complete the code using patient_gender_value_patient_gender_m.checked(); without = true or false.

Using that concept, I was wishfully thinking Access is also has transformed and adopting this approach. Apparently not.

I just saw your latest post. So, it has Click() event not Checked() event.
0
 
LVL 39

Author Comment

by:thenelson
ID: 40582167
Yes, the Click property is used. I was running into problems because the website pulls up different forms for different insurance companies. Although the ID's for the textboxes stay the same from form to form, the gender radio buttons ID's change for different forms. So sometimes the Click property worked and sometimes it didn't.

Thanks for your input.
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40582170
You are welcome. Thank you for the points.

Also for the record, I called event while I should have said method.

I wonder if it will work with () like:

Me.ocxWebBrowser.Document.Forms(0).patient_gender_value_patient_gender_m.Click()
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question