Data entry form

  • Thread starter Thread starter SMILE
  • Start date Start date
S

SMILE

Hi everyone!
I need to create a data entry form in excel. I need only two fields
Stock no. & quantity.

As soon as I enter the stock no. the curser should go to the quantit
column and when I press enter it should store that data in my exce
sheet ( in A1 & B1) and clear the message box for the next entry. Th
next entry should be store in A2 & B2.


Can someone send me the code for it.
Appreciated
Tom
 
instead of creating a form, why dont you use the inbuilt data form?

go to Data - Form and check whether this fits your requirement.

alternately, if you would like VBA to popup this form, use:

Sheet1.ShowDataForm

if Sheet1 has the two columns wherein you would like your data placed
 
Back
Top