Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Retaining focus on a textbox / listbox item pair after validation = false.


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to pair each item on one list to each item on another list Peter R. Excel Worksheet Functions 1 August 24th 07 03:04 AM
How to tell what textbox got the focus vqthomf Excel Programming 2 November 18th 05 01:09 PM
Retaining value of a string from a textbox on a form ?? Dan Thompson Excel Programming 6 October 28th 04 09:00 PM
TextBox Focus Tom Ogilvy Excel Programming 0 June 3rd 04 04:55 PM
Retaining text formatting in TextBox Tom Ogilvy Excel Programming 0 September 9th 03 08:05 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"