Hello,
I have a sheet that inserts data into the next blank row. the offset 4 value is a date.
Can i have it so when i click the date on this sheet it shows the userform.
what i cant get is how to do it since i dont know what row the date will be in.
I tryed
Please Login or Register to view this content.
Last edited by D_Rennie; 07-15-2009 at 10:49 AM.
Give this code a try.
You had your worksheet code in the wrong module. Worksheet code must go in the worksheet module, not in "Thisworkbook" module.
Right click the sheet tab, choose View Code, then paste this code into the code window.
Please Login or Register to view this content.
Perfect, Thankyou.
Just put in for blank cell If Target.Address = rngDate.Address And rngDate <> "" Then
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks