Automation COE
Would you like to react to this message? Create an account in a few clicks or log in to continue.

VBA Scripting in MS-Excel(Macros)

Go down

VBA Scripting in MS-Excel(Macros) Empty VBA Scripting in MS-Excel(Macros)

Post  rvsvimaljamesraj Fri May 09, 2008 1:28 am

Good Morning,

I want to write a VBA Script in MS-Excel Macros such that i could validate a cell for the following condition:
1. Accept only Numbers and characters(in any order)(eg: "48DF" or "RF87" )
2. Should not accept
* Empty spaces
* Special characters (except '_' and '-')
* Symbols as the first letter(eg: "_A1" or "-45C")

Can anyone help me in this issue.

Also I need reference books for VBA scripting in MS-Excel(Macros)

Thanks and Regards,
Vimaljamesraj.RVS

rvsvimaljamesraj

Number of posts : 1
Registration date : 2008-03-03

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum