Clear contents of Combobox in Multipage user form

11-17-2003, 07:12 AM

pemnuts

Regular

Join Date: Jun 2003

Posts: 57

Clear contents of Combobox in Multipage user form

I would like to have a command button on a multipage, that when clicked, it would clear the contents of the comboboxes and text boxes on that page.

Thanks for any input everyone

11-17-2003, 10:08 AM

Kluz

Sapience.Aquire

Super Moderator
* Expert *

Join Date: Oct 2003

Location: Lake Bluff, Ill., U.S.

Posts: 3,306

Code:

Textbox1.Value = ""
Combobox1.Value = ""

'to clear the combobox list:
Combobox.Clear

__________________
No the other right mouse click

11-18-2003, 05:12 PM

pemnuts

Regular

Join Date: Jun 2003

Posts: 57

Quote:

Originally Posted by Kluz

Code:

Textbox1.Value = "" Combobox1.Value = "" 'to clear the combobox list: Combobox.Clear

Thanks Kluz - just what I needed =)

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Form oddity - How do I make a user form inactive but visible	Francois	Excel	9	09-27-2004 02:52 PM
PictureBox contents disappearing when I open a another form in the application.	debbied	General	2	01-14-2004 07:43 PM
How to clear User FOrm Option Button	dppatt	Excel	1	06-24-2003 03:48 PM
can i clear the whole combobox in one go? eg not knowing number of contents	aaa	General	1	02-25-2003 02:44 AM
Color Palette in User Form	MJD	Word, PowerPoint, Outlook, and Other Office Products	1	04-10-2002 05:26 PM