Dropdown list, Macro

excelledsoftware · #8 10-27-2013, 01:51 AM

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.

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