Data form use

[Geoffrey1231]

Hi all,
A couple of, hopefully simple, questions;
How do you force that only caps be entered in a cell?

Also, is there a way to have excel automatically open the data form at startup to encourage entries in the spreadsheet be done via the form?

This is for excel 2000.

Thank you,

Geoff

 

[lenze]

Record a macro to display the form. Copy it to the ThisWorkBook module under the ON Open Event.

I have to think about the CAPS question

lenze

BTW: While you are using a dataform, check out John W's enhanced form at

http://www.j-walk.com/ss/

 

[Tazguy37]

Hi all,
A couple of, hopefully simple, questions;
How do you force that only caps be entered in a cell?

Do you want text entered in the cell to be forced to caps or give an error? VBA has the UCase() function for conversion.

If you wanted to detect something other than uppercase in a cell, so that you could tell the user they've made an error, that would probably be harder. You might have to go through each character and test for case.

 

[Geoffrey1231]

Thank you Tazguy37, I'll try the ucase function.

Geoff