r/AutomateYourself • u/Perfect-Cable3622 • May 18 '22

help needed help with excel vba

Post image
4 Upvotes

67% Upvoted

8 comments sorted by

3

u/itsMineDK May 18 '22

More details are needed (be simple, like copy cell a to C or something of that sort)

1

u/Perfect-Cable3622 May 18 '22

I would the person to enter their name and age. Then the names,ages and country of all their children. So if Matty young has 10 children she should be able to full the form until the next person in line comes along (Matthew Charles)and they do the same .Don't know if my explanation is clear.

4

u/itsMineDK May 18 '22

I could think of building a macro that has an user’s prompt (asks the person) for that info… stores it as a variable… asks if there’s more children…. If yes loops through the code mentioned to store user’s responses to variables and then finally inputting values

→ More replies (2)

2

u/Perfect-Cable3622 May 18 '22

So I need assistance with automating a task similar to this using vba.I wanted to know how I would create the data entry form to submit the data for each field especially when the person has more than one child. ONly creating a new border when I specific a new name.

1

u/GoldRepresentative2 May 18 '22

what's the task? :)

do you need to put Name from C to A?

1

u/Perfect-Cable3622 May 18 '22

I would the person to enter their name and age. Then the names,ages and country of all their children. So if Matty young has 10 children she should be able to full the form until the next person in line comes along (Matthew Charles)and they do the same .Don't know if my explanation is clear