Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to activate command button on form by macro
I'm working on a macro to load, fill out, and run a form. I think I
know how to do everything except run the form. By run the form I mean "click" the OK command button. Here's basically what I have (in the same workbook as the form): Load MyForm MyForm.textbox = "some text" MyForm.OKbutton.SetFocus Application.SendKeys "{ENTER}" I thought I could set the focus to the OK command button and send the ENTER key but that isn't working. Should this work or is there some other way to click the OK command button? Denis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro attached to command button - VBA form | Excel Discussion (Misc queries) | |||
Accessing the text of a form command button from underlying macro | Excel Programming | |||
Command Button vs Form Button | Excel Programming | |||
Macro to activate form button | Excel Programming | |||
using 'enter' on a textbox to activate a command button? | Excel Programming |