Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everybody.
I have a wee problem that has evaded my best efforts over the past couple of days and I hope one of you out there can shine some light for me. The problem centres on two form controls. Essentially there is a text box and a list box. For each entry of the list the user must enter a conversion rate into the text box. The user clicks a list item then enters a value into the text box. The user then either clicks another list item or decides to do something else. My problem begins with validation of the text box entry. I do not wish to use a textbox_change event, but rather wait until the user clicks another list item or other control, before I trigger the validation. If validation is true, no problems. However, if validation is false, eg. the user entered a word string, no matter how I code it, using textbox_Exit (with Cancel = true, or enable = false then true, etc) or other text box event, or a _listbox event, I am not able to figure out how to both keep focus on the incorrect text box entry and force the list box to stay on the offending list item. My best to date has been to keep focus on the textbox offending entry, but the listbox moves to the new user selection. If anybody can shed some light on how I might do this without having to include a dedicated 'OK' button for each new user entry, I would be most grateful Ciao for now. chatterbox |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
How to tell what textbox got the focus | Excel Programming | |||
Retaining value of a string from a textbox on a form ?? | Excel Programming | |||
TextBox Focus | Excel Programming | |||
Retaining text formatting in TextBox | Excel Programming |