+ Reply to Thread
Results 1 to 3 of 3

UserForm Change of data value event- Label show or hide

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    656

    UserForm Change of data value event- Label show or hide

    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.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,530

    Re: UserForm Change of data value event- Label show or hide

    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.

  3. #3
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    656

    Re: UserForm Change of data value event- Label show or hide

    Hi AlphaFrog,
    Very well done .
    I just played around with code.
    It worked as follows:
    Please Login or Register  to view this content.
    Thank you very much
    Kind Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. UserForm label to show current date
    By Tomtril in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 06:57 AM
  2. [SOLVED] Userform to show date format in textbox or label
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2013, 08:55 PM
  3. [SOLVED] Show label in UserForm
    By jdasp49 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2013, 09:30 AM
  4. Show and Hide Label Controls based on cell on another sheet
    By muzunova in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2011, 02:07 PM
  5. [SOLVED] change the data label of an chart to show qty
    By Trever B in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1