Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code help - onkey
I have put the following code in the module of my main userform;
Sub OnKey Application.Onkey, "{Tab}", "Update" End Sub Sub Update() TextBox586.Value = Worksheets("IncStmtSummary").Range("F5") TextBox586.Text = Format(TextBox586.Text, "$#,##0") End Sub I am attempting to have TextBox586 update whenever the Tab key i pressed. It does not work. Any suggestions. Does it matter where put the code?? Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code help - onkey
Hi
This will work Don't use Onkey for a macro name because Excel think it is code In your other code you have a typo ( , after Application.OnKey ) Sub OnKeySub2() Application.OnKey "{Tab}", "Update" End Sub Sub Update() MsgBox "" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "bforster1 " wrote in message ... I have put the following code in the module of my main userform; Sub OnKey Application.Onkey, "{Tab}", "Update" End Sub Sub Update() TextBox586.Value = Worksheets("IncStmtSummary").Range("F5") TextBox586.Text = Format(TextBox586.Text, "$#,##0") End Sub I am attempting to have TextBox586 update whenever the Tab key is pressed. It does not work. Any suggestions. Does it matter where I put the code?? Thanks. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
code help - onkey
try this:
Private Sub UserForm_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If KeyAscii = vbKeyTab Then Call Update End If End Sub This code must go in the codebehind the form; Update must be a Public routine to work. HTH Tim "bforster1 " wrote in message ... I have put the following code in the module of my main userform; Sub OnKey Application.Onkey, "{Tab}", "Update" End Sub Sub Update() TextBox586.Value = Worksheets("IncStmtSummary").Range("F5") TextBox586.Text = Format(TextBox586.Text, "$#,##0") End Sub I am attempting to have TextBox586 update whenever the Tab key is pressed. It does not work. Any suggestions. Does it matter where I put the code?? Thanks. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
code help - onkey
Oops
You say userform See Tim his reply -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi This will work Don't use Onkey for a macro name because Excel think it is code In your other code you have a typo ( , after Application.OnKey ) Sub OnKeySub2() Application.OnKey "{Tab}", "Update" End Sub Sub Update() MsgBox "" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "bforster1 " wrote in message ... I have put the following code in the module of my main userform; Sub OnKey Application.Onkey, "{Tab}", "Update" End Sub Sub Update() TextBox586.Value = Worksheets("IncStmtSummary").Range("F5") TextBox586.Text = Format(TextBox586.Text, "$#,##0") End Sub I am attempting to have TextBox586 update whenever the Tab key is pressed. It does not work. Any suggestions. Does it matter where I put the code?? Thanks. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
onkey help | Excel Programming | |||
onkey | Excel Programming | |||
Onkey Method | Excel Programming | |||
Onkey Error | Excel Programming | |||
Onkey | Excel Programming |