I can't seem to locate the command button properties any longer. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. Now when I open the workbook, the buttons don't work! When I click them nothing happens. Then I saved and closed the workbook and went to lunch. I added the _Click code to run the macros when the user clicked the buttons.Īll of the buttons were working fine. I got into the button properties and set the background colors. So I removed the form control buttons and created new ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. I'm having a problem in a workbook with several ActiveX command buttons. document.getelementbyid("fPassword").Value = " Password "
document.getelementbyid("fUserName").Value = " UserName " Set appIE = CreateObject("InternetExplorer.Application") The link is: ĭim appIE As Object ' InternetExplorer.Application I highlighted another section in green that I took from a previous post hoping it would solve my problem. The code runs without errors, but doesn't actually "hit" the submit button on the webpage.įor posting, I removed my actual user name and password and and used the generic " User Name " and " Password " highlighted in blue. So far I can get everything to work besides the Submit part.
I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button.
0 kommentar(er)
