Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

data entry macro

  Asked By: Lynda    Date: Jan 21    Category: MS Office    Views: 771
  

i have a simple task that i wnat to automate.

i need to enter data in a certain sequence:

enter yyyy
move right
enter mm
move right
enter dd
move right
move right
enter a number as text
move right
enter a string
move right
enter a string
move right
enter a number as double
move right
enter a number as double
move right
move down one row
move to the beginning column and start all over again util control-
break

I can do most of the looping and error chcking thing, but believe it
or not i do not know how to get the entered data into the cell like

cells(iCurCol,iCurRow).value = [entered data]

how do i put the entered data into the value.

Thanks for any hint. I know it got to be something stupid or so
simple that i can see it.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jo Fowler     Answered On: Jan 21

You do it just how you said except where you have put  Entered Data you either
put the value you want to enter  (this can be quoted text like "August" or a
numeric value like 47.839. Or you can have a variable like this


iMyYear = Year(Now())
Cells(iCurCol, iCurRow).Value = iMyYear

 
Didn't find what you were looking for? Find more on data entry macro Or get search suggestion and latest updates.




Tagged: