PDA

View Full Version : Recall data to my userform



wiehan1981
06-05-2012, 11:37 AM
Hi people,

Man the code writing is NOT easy. I have a userform that records data to a worksheet. On my userform i can select "add" or "edit", now add is obvious, you enter the info and the data gets recorded on a new row. but if i want to edit existing data i select the "edit" option and you enter a existing employee id and it must recall that employees detail to the userform for editing, this is where my problem lies. I'm VERY new with VBA code and can't seem to figure out the code for recalling data. Please can someone help or point me in a direction, preferably the right one.

Attached is the worksheet aswell.

Tinbendr
06-05-2012, 06:24 PM
Lightly tested.

Couldn't get the board to take a file, so here ya go. (https://www.box.com/shared/bgmyv0fbsk)