Hi all,
I have userform and it works fine.
It also can edit as well ( Finally)..
When I open userform and populate existing data :
-Textbox14 has a date value
-I have attached a Label13 ' Date?' and has red colour text.
Now I am trying that the date value in textbox14 is less than today() then Label13 is visible
Otherwise it is not visible.
Just cant get it work.
Please help
Kind regards
Please Login or Register to view this content.
Today() is a worksheet function and not a VBA function. Use Date in VBA instead.
Try this (not tested)
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi AlphaFrog,
Very well done .
I just played around with code.
It worked as follows:
Thank you very muchPlease Login or Register to view this content.
Kind Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks