Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simulate a enter key behaviour?
Hi everyone
i don´t know if this is possible. i have a group of textboxes that on tab/enter key the cursor moves to the next box. my problem is that i have a group of frames and i want that on me.textboxgroup in frame1 the cursor "move" to me.textboxgroup on frame2. i have made: while flag=0 if isntr(me.textboxgroup.name,"BOX")=0 '-----here is the code i want for keycode=enter and jump to the private sub textbox_keypress() again - to jump for the next textbox wend is this possible, to simulate a enter key and jump to the keypress sub??? thanks very much Miguel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
simulate a enter key behaviour?
SendKey "{ENTER}" Shinya "Liedson31" wrote in message ... Hi everyone i don$B!-(Bt know if this is possible. i have a group of textboxes that on tab/enter key the cursor moves to the next box. my problem is that i have a group of frames and i want that on me.textboxgroup in frame1 the cursor "move" to me.textboxgroup on frame2. i have made: while flag=0 if isntr(me.textboxgroup.name,"BOX")=0 '-----here is the code i want for keycode=enter and jump to the private sub textbox_keypress() again - to jump for the next textbox wend is this possible, to simulate a enter key and jump to the keypress sub??? thanks very much Miguel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
simulate a enter key behaviour?
Miguel,
You can use the SendKeys method to send a carriage return -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Liedson31" wrote: Hi everyone i don´t know if this is possible. i have a group of textboxes that on tab/enter key the cursor moves to the next box. my problem is that i have a group of frames and i want that on me.textboxgroup in frame1 the cursor "move" to me.textboxgroup on frame2. i have made: while flag=0 if isntr(me.textboxgroup.name,"BOX")=0 '-----here is the code i want for keycode=enter and jump to the private sub textbox_keypress() again - to jump for the next textbox wend is this possible, to simulate a enter key and jump to the keypress sub??? thanks very much Miguel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simulate Check Box | Excel Discussion (Misc queries) | |||
simulate values for a given Mean and Standard deviation | Excel Discussion (Misc queries) | |||
Simulate Click Event | Excel Programming | |||
how to change (override) enter key behaviour in a cell | Excel Programming | |||
How to simulate worksheet rename event | Excel Programming |