Retreiving values from other worksheet

[rsk77]

i have a worksheet with some text field,when the user saves it,the values are saved in the other worksheet,now when the user is selecting teh same criteria like date then those details taht are previously stored must be populated..how to acheive this functionality.

 

[mpopnoe]

Please be more specific, when you refer to "text field" are you using a userform? Please describe your program in more detail so I can help you.

thanks
mike

 

[rsk77]

text feild means a textbox not a user form.

 

[xlbo]

I think Mike was asking whether the textbox was contained within a userform or whether it is embedded on a worksheet - different syntax will apply Rgds
~Geoff~

 

[mpopnoe]

xlbo,

Thanks, that was what I was getting at.

rsk77,

Without any more info, I'm assuming (which is never good) that your trying to bring data from the worksheet cells into your form controls. You mentioned that when the user selects a date value this saved data should be displayed. Use one of the events of whatever control your using for date selection and place code there that references the value/text from the worksheet where you saved the data.

(code in the userform, placing data into a textbox)
txtDataFromWorksheet.Text = ThisWorkBook.WorkSheets("YourWrkSheet&quot.Cells(1, Range("First_Name&quot.Column).Text

**Note: This was the best I could do with the info you provided, please be more specific if this doesn't help.

mike