Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a UserForm with a TextBox and a CommandButton. I want to write some text on the TexBox using the 'SendMessage' API when the CommandButton is clicked . I am able to get the window handle of the TextBox control by using the 'apiGetFocus' but for somw reason, the text is not added !!!! Code: Private Declare Function apiGetFocus Lib "user32" Alias "GetFocus" () As Long Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" _ (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long Const WM_SETTEXT = &HC Private Sub CommandButton1_Click() TextBox1.SetFocus Hndle = apiGetFocus SendMessage Hndle, WM_SETTEXT, 0, ByVal "WOW!" End Sub Any help would be much appreciated. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |