Hello there. Looking for code that will unhide row if i input data from userform. userform inputs data in (a)general and (b)date. c and d = formula. yeah, and how to autocopy this formula to next cells?
Hello there. Looking for code that will unhide row if i input data from userform. userform inputs data in (a)general and (b)date. c and d = formula. yeah, and how to autocopy this formula to next cells?
Last edited by pulss; 03-22-2016 at 10:33 AM.
Kind regards![]()
Please Login or Register to view this content.
Leo
Sorry I forgot the formula, to let this work remove the code from textbox
Input in texbox for date can be
d-m-yy dd-mm-yyyy d/m/yy dd/mm/yyyy
output in sheet is dd/mmm/yy
Kind regards![]()
Please Login or Register to view this content.
Leos
Niice that was fast. unhide works
there is one more formula cells(nr, 4). and is there possible add code for conditional formating to entire row if it expired or expired soon?
something wrong in formula?
![]()
Please Login or Register to view this content.
nevermind i fount it out
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks