John_McClane
New Member
- Joined
- Apr 30, 2013
- Messages
- 27
Hi guys,
I've been looking around for ages but can't seem to find anything similar to what I'm looking for.
I have a spreadsheet with a list of peoples names running down column A starting at A15 to A90 (The range will grow and shrink) A14 is labelled name. b14 is option 1, c 14 option 2 etc until option 12.
In each corresponding cell there is a date. So for example, Steve McQueen's Option 1 date would be 12/12/2001 in column b32 say.
I have a userform to add new data to the sheet and it works perfectly (thanks to this forum). I would really like to have a userform to edit data already in on the sheet.
So i would have one combobox with a list of all the names in the range A15:A90 and then a second combobox with the headings in the range b14:b26 and then once you've selected both the text you type into a textbox beneath will fill the selected cell.
I hope this makes sense. Thank you in advance, any help would be much appreciated.
I've been looking around for ages but can't seem to find anything similar to what I'm looking for.
I have a spreadsheet with a list of peoples names running down column A starting at A15 to A90 (The range will grow and shrink) A14 is labelled name. b14 is option 1, c 14 option 2 etc until option 12.
In each corresponding cell there is a date. So for example, Steve McQueen's Option 1 date would be 12/12/2001 in column b32 say.
I have a userform to add new data to the sheet and it works perfectly (thanks to this forum). I would really like to have a userform to edit data already in on the sheet.
So i would have one combobox with a list of all the names in the range A15:A90 and then a second combobox with the headings in the range b14:b26 and then once you've selected both the text you type into a textbox beneath will fill the selected cell.
I hope this makes sense. Thank you in advance, any help would be much appreciated.
