#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Re-post

George,
As others have stated, it is rather confusing to the user (and unusual
Windows design) to offer options that are not valid. If these are some kind
of separator, then maybe a change of design (option/check boxes) would be
more appropriate.
However, I would use a combobox from the Controls Tools box and then you can
use it's properties (.ListIndex etc) to see what was selected and reset if
required.

NickHK

"George" wrote in message
ups.com...
Hi, All:

I have a Form Combo Box which has 5 options. The default option is
either Option1, Option2 or Option 5.

If the user switches between those 3 options, we do NOT need to do
anything. However, if the user wants to
switch from the default option (1, 2 or 5) to EITHER Option 3 OR
Option4, I will need a warning message "This is for decoration ONLY.
Please DO NOT attempt to select this. Thanks,". Then the user will
click "Ok" and
the option stays as the previous one.

Any help will be highly appeciated!

Thanks,



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
Post Newfie809 Excel Worksheet Functions 2 October 22nd 09 09:47 PM
will this post jaci Excel Discussion (Misc queries) 2 February 11th 09 07:43 PM
Should I generally request "post a poll" when I post a new thread? Joe Miller Excel Discussion (Misc queries) 2 January 7th 06 04:46 PM
My First Post! gago818 Excel Discussion (Misc queries) 2 October 24th 05 01:55 AM
VBA Post inspirz Excel Programming 4 July 14th 05 06:57 PM


All times are GMT +1. The time now is 08:46 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"