LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default How to automatically clear cells upon changing/making selectio

In the last statement It should have been use the click event for the
combobox where the user selects a new model or perhaps a new product.

--
Regards,
Tom Ogilvy


"Ingeniero1" wrote:


Tom, you said-
-"It would seem that you are already doing that to populate the choices
for the other comboboxes?"-

You are correct IF the user clears all the combo boxes between models
before filling them.
But if they are not cleared first, it is possible to miss one and leave
it with the previous information.
What I am trying to learn how to do is to make the clearing of the
boxes a must or make it happen automatically.

-"If not, then use the click event for the model."-
Could you expand on this?

Thanks!

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=533424


 
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
Clear cells automatically bigmaas Excel Discussion (Misc queries) 7 March 3rd 10 04:13 PM
Automatically clear values from a range of selected cells John Davies Excel Discussion (Misc queries) 1 June 28th 05 04:42 PM
Making Cells Automatically Add #'s Instead of being written over UBER_GEEK Excel Programming 3 June 18th 05 10:34 AM
How do I clear data in selected cells automatically Jim Train Excel Discussion (Misc queries) 1 May 25th 05 06:45 PM
cells not changing selection after sheets array Simon Lloyd[_477_] Excel Programming 4 June 9th 04 03:23 PM


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

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

About Us

"It's about Microsoft Excel"