jinx_uk_98
Board Regular
- Joined
- Jul 3, 2005
- Messages
- 105
Hi all,
On a form I have 2 textboxs. In textbox1 the user will enter a date and in textbox2 they will enter a value.
What code do I need to attach to a button to lookup up the date from textbox1 (the dates are listed on sheet1 a1:a50) then copy the text from textbox2 in the relevant cell next to the looked up date.
I hope that makes sense, any help greatly appreciated
Kevin
On a form I have 2 textboxs. In textbox1 the user will enter a date and in textbox2 they will enter a value.
What code do I need to attach to a button to lookup up the date from textbox1 (the dates are listed on sheet1 a1:a50) then copy the text from textbox2 in the relevant cell next to the looked up date.
I hope that makes sense, any help greatly appreciated
Kevin