PDA

View Full Version : Solved: Passing Value back to userform



MRichmond
02-07-2012, 09:47 AM
Good day to you all

I have, what I'm sure is, a simple problem with a userform.

Everything works as it should, a user clicks on add new, and a blank userform is presented. They fill in the required fields (all except the log no), click save and the data is stored on teh hidden worksheet "Data" on teh next empty row.

However, when the user clicks save I would like the Log no to be displayed in the relevate text box.

I'm sure this is probably only one or two lines of code, but it's been driving me mad all day trying to figure it out.

If anyone could help I'd be most grateful.

Sample workbook attached

Thanks in advance for the help

Bob Phillips
02-07-2012, 10:13 AM
Add



Me.txtLogNo.Text = mcRecord

before the save procedure exit.

MRichmond
02-07-2012, 10:46 AM
Thanks XLD, as always you are a great resource.