Dropdown list, Macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Dropdown list, Macro

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-27-2013, 01:51 AM

excelledsoftware excelledsoftware is offline

Windows 7 64bit Dropdown list, Macro

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Quote:

Originally Posted by excelledsoftware

If you want to make this macro do the same but check with any value from 1 to 100 it is very easy to modify the code to do this and it will run just as fast.

My apologies the code will not run just as fast since it will check in increments of 1. The regular code runs in less than a second but this method above takes about 3 seconds. Still pretty quick by I wanted to correct my inaccurate statement.

« Previous Thread | Next Thread »

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA: How to place dropdown list next to text	YigalB	Word VBA	0	08-11-2013 01:48 PM
block selection in dropdown list	Intruder	Excel	2	01-10-2013 10:20 AM
dropdown list for documents	r_p_t_0	Word	2	12-18-2012 05:55 AM
Can I have a dropdown list to choose from in mail merge?	lawlaw	Mail Merge	3	11-29-2012 04:47 PM
Dropdown list of email addresses	J Partridge	Outlook	1	01-13-2011 06:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 PM.