Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 09-19-2020, 08:46 PM
Guessed's Avatar
Guessed Guessed is offline Combo Box/List Box (using IF commands?) Windows 10 Combo Box/List Box (using IF commands?) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I'm not a fan of doing work to re-create what I think you have in order to show you something that may or may not match. Please post a sample doc that shows your current code.

In the case of the code you have posted, the Change event on ComboBox1 shouldn't start by adding more values into the list of that same control and then changing the value of to the first item (which causes the same event to run). Doesn't this seem like an infinite loop to you?

It is generally poor practice to show a list and then when you user makes a selection from that list, suddenly add another couple of options to the list and change the selection to the original first item in the list.

You don't need multiple forms, a single form should do everything you need. Having multiple forms just forces you to reproduce and manage the same code in lots of different places.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box/List Box (using IF commands?) Changing Drop Down List to Combo Box workingspade Word 7 06-13-2024 01:17 AM
Combo Box/List Box (using IF commands?) Take an Excel List and Add to Word Combo Box dlafko1 Word VBA 9 04-12-2019 06:24 AM
Letter Template /w combo box list etruz Word 4 10-31-2018 05:16 AM
Format Font Size in Combo Box List lukewarmbeer Word VBA 0 08-27-2011 07:28 AM
Bold list items in a combo box DrewB Word VBA 0 07-17-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft