Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making hotkey in textbox in userform
Private Sub CommandButton3_Click() Application.OnKey "{F3}", "uMain.ddd" End Sub Sub ddd() Me.textbox1.SetFocus End Sub the upper source does not work. i want to make a hotkey(shortcut) the specific textbox control. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making hotkey in textbox in userform
Try:
Private Sub CommandButton3_Click() Application.OnKey "{F3}", "ddd" End Sub Sub ddd() ActiveSheet.Shapes("TextBox1").Select End Sub Sub ResetKey() Application.OnKey "{F3}", "" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select [a1]cell when hotkey(ctrl+q) pressed, after userform load | Excel Programming | |||
Making a TextBox look and feel like a Label in a userform | Excel Programming | |||
Making a TextBox look and feel like a Label in a userform | Excel Programming | |||
Making a TextBox look and feel like a Label in a userform | Excel Programming | |||
Making a TextBox look and feel like a Label in a userform | Excel Programming |