Userform ActiveCell question

[Noz2k]

What I want to know is how to have a variable activecell?

So I already have a table which is populated by a userform. However once this initial data is input a follow up form has to be completed at a later date.

So what I am trying to do is make it so that the follow up form sends data to the correct row in the table.

e.g. To keep it simple if my table is like (assuming "Name" is in A1)

Name StartDate EndDate
James 23/01/09
Brad 28/04/09

with my first form posting Name and StartDate, and then the follow up form posting EndDate. How would I make it so that the form posts for Brad (in C3) rather than James (in C2)?

 

[Noz2k]

I would use data validation but I need the list range to be dynamic, and have more than 8 options (which I think that is limited to).

Not sure which I'm using, but it doesn't have the list property, so I'll try the other on Monday morning.

Thank you so much for your help

 

[Norie]

You aren't restricted to 8 items in a data validation list, and you can use dynamic ranges.

It sounds like you are using a Forms control rather than an ActiveX -you can use List with an ActiveX.