Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Bill Renaud wrote: It looks to me like you should add an "Update" button for the user to click after they have selected an item in the list, then entered the conversion rate in the text box. This could be the default button. When the user presses the return key, validation would be performed, and focus returned to the text box for editing, if necessary. Otherwise, if the user simply selects another list item, Excel doesn't know whether to apply the conversion rate to the previously selected list item. Maybe nothing should be done, because the user simply selected the wrong item in the list box. Good form design usually means that the Cancel button also exits from the form, just like the OK button, but any changes are cancelled (undone). If the user selects an item in the list box, enters a conversion rate in the text box, and then decides to hit the Cancel button, what should happen? Should all previous changes/entries be undone? -- Regards, Bill Thanks Bill for the advice. I started down the road you advised, but then had an all too rare flash of inspiration. I used the textbox_Exit event to kick off the validation. If it validated good, no action was taken. If it validated false it locked the list box, passed a message to the user and set focus back on the text box. I have included OK and Cancel command buttons as you suggest. Thanks again. chatterbox |
Reply |
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 |