Validation and Combo box question
Posted on 2003-02-19
Hi. Im just starting to use Visual Basic for a school project so my skills are limited to say the least. The VB I am using is only the version in Excel so it is not very powerful. It has taken me a good few days to get to where I am but now I am stuck so was wondering if any of you guys could help me. I have 3 questions. The first is:
Is there a way to force people to only be able to enter letters and all symbols such as [?!"#$%^&*()>.] but no numbers into a textbox in excel VBA.
The second is:
Is there a way to use a combo box in a UserForm that by the selection you make, determines which UserForm you go to. e.g. if i select 1 from the combo box, it takes me to UserForm 1 or if I select 2 from the combo box it takes me to UserForm2.
The third is:
Is there a way to get TextBoxes that are linked to a cell in Excel to reveal what the cell value is in the TextBox without having to put the cursor in the TextBox first. The Code I use currently to link to the cells is:
TextBox1.Text = Range("cell").Value
These are probably very basic questions but i cant find a way to do them and have searched lots of forums looking for the answer. Any help you can provide will be greatly appreciated.