Variable arrays from user input

SeattleITguy · #2 01-29-2015, 09:19 AM

Found a working solution...

Instead of creating an array I just used and IF/OR statement:

Code:

If SpreadsheetTitle = "Customer" Or SpreadsheetTitle = "customer" Or SpreadsheetTitle = "cust" Or SpreadsheetTitle = "Cust" Or SpreadsheetTitle = "C" Or SpreadsheetTitle = "c" Then

But I am sure this is not the best way to do it but it works exactly like I need it to.

If anyone knows why this isn't the most efficient way or a better way to do this please chime in.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Taking input from InputBox from user	SeattleITguy	Excel Programming	1	01-28-2015 09:05 AM
User input to a variable on the document	dsm1995gst	Word VBA	1	09-03-2013 03:43 PM
Replacing text with user input.?.?.?	brad1977	Word	3	11-20-2012 10:20 AM
Help with VBA macro - Variable input	sc30317	Excel Programming	0	08-31-2011 01:00 PM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM