Pop-up input boxes with data validation

**tony0710** · 02-20-2009, 03:47 AM

Hi - Thanks to VB Noob for solving:

http://www.excelforum.com/excel-prog...ml#post2046118

Now another question:

Once cursor moves to C1, I'd like a pop-up input box to appear, in which the user has to enter in a a numerical digit. Also a method by which to validate that the digit is indeed a number and not text, plus it cannot be "zero" i.e: the lowest number is to be "1" not "0".

Once C1 is populated, then I would like the cursor to move to D1 and another pop-up input box to appear - this time to be populated by user entering 2 letters only - again to be validated.

Once D1 is populated, I would like cursor to move to A2.

I've seen code on the forum for input boxes - but just am uncertain how to add to the code that VB Noob done above and to make sure about the validation.

Thanks in advance

**royUK** · 02-20-2009, 04:15 AM

That's a bit time consuming, why not use a userform like the one in the DatabaseForm example here

http://www.excel-it.com/vba_examples.htm

**tony0710** · 02-20-2009, 04:46 AM

Hi

Thanks for that Roy - will look into that.

But I done this for meantime - it's VERY basic though and no validation:

Please Login or Register  to view this content.

**tony0710** · 02-20-2009, 01:10 PM

Hi

Through a bit more research I managed to do the following:

Please Login or Register  to view this content.

So all appears to be working fine except for the fact that in the second inputbox, one can still enter numbers - so is there a "type number" that I can use to ensure that only text is used?

**royUK** · 02-20-2009, 01:47 PM

Try this

Please Login or Register  to view this content.

**tony0710** · 02-21-2009, 07:57 AM

That's great!!

Can the same be applied to the first box, to come up with a Input Error message to say that the value entered has to be higher than zero - for example (assuming that you Dim y

Please Login or Register  to view this content.

Also in the second box - it still accepts initials with numbers e.g. s4s - anyway of limiting the input to the alphabet only?

**tony0710** · 02-21-2009, 10:42 AM

Ok ... I've managed to:

Please Login or Register  to view this content.

So now there is only one outstanding problem - the second input box "intials" is still able to accept combination of text and numbers e.g. s4s - I only want it to accept text i.e. ss. ALSO, it appears that it can also accept a blank " " - basically just hitting the enter leaves the cell bank.

So how to alter code to stop this from happening?