Comments for SmittyPro http://www.smittypro.com/Blog Witticisms, Help, Tutorials and More Tue, 07 Sep 2010 00:51:42 +0000 http://wordpress.org/?v=2.7.1 hourly 1 Comment on Automating Data Entry with Data Validation Lists by admin http://www.smittypro.com/Blog/?p=25&cpage=2#comment-373 admin Tue, 17 Aug 2010 18:30:53 +0000 http://www.smittypro.com/Blog/?p=25#comment-373 What do you mean by multiple choice? Can you clarify? You can have multiple options in a validation list, but I need a better idea of what you're trying to accomplish. What do you mean by multiple choice? Can you clarify? You can have multiple options in a validation list, but I need a better idea of what you’re trying to accomplish.

]]> Comment on Automating Data Entry with Data Validation Lists by MP http://www.smittypro.com/Blog/?p=25&cpage=2#comment-372 MP Tue, 17 Aug 2010 18:18:33 +0000 http://www.smittypro.com/Blog/?p=25#comment-372 Can you create multiple choice using a validation list? Can you create multiple choice using a validation list?

]]> Comment on Automating Data Entry with Data Validation Lists by admin http://www.smittypro.com/Blog/?p=25&cpage=2#comment-371 admin Sun, 15 Aug 2010 18:27:00 +0000 http://www.smittypro.com/Blog/?p=25#comment-371 You can use: Application.DisplayAlerts = False Which will suppress those messages. Just make sure to set it back to True at the end of your code because the VBE won't reset it. Sory for taking so long to respond, but I just got a new PC up and running after my old one died. You can use:

Application.DisplayAlerts = False

Which will suppress those messages. Just make sure to set it back to True at the end of your code because the VBE won’t reset it.

Sory for taking so long to respond, but I just got a new PC up and running after my old one died.

]]> Comment on Automating Data Entry with Data Validation Lists by admin http://www.smittypro.com/Blog/?p=25&cpage=2#comment-370 admin Sun, 15 Aug 2010 18:26:05 +0000 http://www.smittypro.com/Blog/?p=25#comment-370 I'm not sure. You can e-mail me the file and I'll take a look. (Sorry for the late reply - I've been building a new PC). I’m not sure. You can e-mail me the file and I’ll take a look. (Sorry for the late reply - I’ve been building a new PC).

]]> Comment on Automating Data Entry with Data Validation Lists by Fabri http://www.smittypro.com/Blog/?p=25&cpage=2#comment-369 Fabri Thu, 12 Aug 2010 14:03:54 +0000 http://www.smittypro.com/Blog/?p=25#comment-369 Hi I've managed to create a project that automatically opens and excel file then at a pre defined time execute a macro. about half way through i get a message box that asks if i want to replace the contents of a cell. Is there a way i can automate a yes click on this box??? Hi I’ve managed to create a project that automatically opens and excel file then at a pre defined time execute a macro. about half way through i get a message box that asks if i want to replace the contents of a cell. Is there a way i can automate a yes click on this box???

]]> Comment on Automating Data Entry with Data Validation Lists by Pooja http://www.smittypro.com/Blog/?p=25&cpage=2#comment-368 Pooja Fri, 16 Jul 2010 09:02:41 +0000 http://www.smittypro.com/Blog/?p=25#comment-368 Hi, The “Show error alert after invalid data is entered” is checked. Is this a bug or is there some other issue? Hi,
The “Show error alert after invalid data is entered” is checked. Is this a bug or is there some other issue?

]]> Comment on Automating Data Entry with Data Validation Lists by admin http://www.smittypro.com/Blog/?p=25&cpage=2#comment-367 admin Fri, 16 Jul 2010 04:09:45 +0000 http://www.smittypro.com/Blog/?p=25#comment-367 Nope, just use a named range. Then anytime you make a change in the range it will automatically update in Data Validation. Nope, just use a named range. Then anytime you make a change in the range it will automatically update in Data Validation.

]]> Comment on Automating Data Entry with Data Validation Lists by admin http://www.smittypro.com/Blog/?p=25&cpage=2#comment-366 admin Fri, 16 Jul 2010 04:09:02 +0000 http://www.smittypro.com/Blog/?p=25#comment-366 You need to make sure that "Show error alert after invalid data is entered" is checked on the Error Alert tab. You need to make sure that “Show error alert after invalid data is entered” is checked on the Error Alert tab.

]]> Comment on Automating Data Entry with Data Validation Lists by Pooja http://www.smittypro.com/Blog/?p=25&cpage=2#comment-365 Pooja Thu, 15 Jul 2010 11:36:28 +0000 http://www.smittypro.com/Blog/?p=25#comment-365 Also.. I am trying to automate this procedure as my list will keep changing. What would you suggest is the best way to do it? Is it better to create a macro and then run the macro every time I want to do it or will I have to write a vb script and source the list in it every time? Also.. I am trying to automate this procedure as my list will keep changing. What would you suggest is the best way to do it? Is it better to create a macro and then run the macro every time I want to do it or will I have to write a vb script and source the list in it every time?

]]> Comment on Automating Data Entry with Data Validation Lists by Pooja http://www.smittypro.com/Blog/?p=25&cpage=2#comment-364 Pooja Thu, 15 Jul 2010 11:33:54 +0000 http://www.smittypro.com/Blog/?p=25#comment-364 Hi, Loved the method 2. I've created the drop down and done all that is required for displaying an error message. However, i can still enter values that are not present in the list and the error message pop up does not appear as well. Hi,
Loved the method 2. I’ve created the drop down and done all that is required for displaying an error message. However, i can still enter values that are not present in the list and the error message pop up does not appear as well.

]]>