User form problems

**lapot** · 12-14-2006, 12:49 PM

Can some one help please?
I found this excel form on the forum and tried to change some of it, for my use but I am stuck at some point. Please click on OPEN FORM button on the sheet then help me.
Here is my list of points that I want be able to when I m using this form ;
I like to have

1-if I leave BANKED section blank I like the whole Row text turn in red so that I know that cheque has not been banked.
2-When I enter date I want excel sheet date format as text format like 15-Apr-2006.
3-Is it possible to have text format in capital letters for all boxes in user form.
4-How do I get rid of grey colour on the excel sheet then it looks normal cells.

Thank you for your time

**lapot** · 12-15-2006, 11:52 AM

I guess it was a bit difficult question no one helped me yet.

**Carim** · 12-15-2006, 12:03 PM

Hi,

If I may add a suggestion ...
It is not a question of difficulty or complexity ... rather, when questions or inquiries tend to become assignments, many people do not bother addressing all the different issues ...

My suggestion is to break down your problem into stand-alone questions ...
You will very probably get answers to each one of them ...

HTH
Carim