+ Reply to Thread
Results 1 to 4 of 4

Display a notice when a locked control on a form is clicked

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Display a notice when a locked control on a form is clicked

    Does anything fire that I can use to display a notice when a locked control on a form is left clicked on?

    If not, I suppose I could modify my use of ControlTipText on a control-by-control basis.

    Yes, this question is a lot less wordy than my normal, but I am filling up a few words to try not to disgrace my reputation...

    Thank-you!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Display a notice when a locked control on a form is clicked

    I don't think you can trap click event when control is locked.

    Typically I'd just use Enabled "False" instead of locking it.

    This will gray out text on the button, so it's clear it is disabled. If needed, you can also change caption when button is disabled (via code).

    0.JPG
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: Display a notice when a locked control on a form is clicked

    how about make it look disabled - set the font color to gray - to fool the user that its disabled.
    then on the click event, set two conditions, if the font color of the button is gray, do this. and if the font color of the button is black, then do the normal code.
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.

  4. #4
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Re: Display a notice when a locked control on a form is clicked

    Thank you, very much!

    If I can not "trap" a clicked locked control I will definitely be considering these options.

    Just as a note, I do also group in the term "Controls" items such as textboxes and listboxes, and I further have most colored differently when locked, but I was hoping for a little "Hey! Dummy! Click the ""Edit Mode"" button if you want to edit this setting" type message, as in the past, I have been the dummy...

+ 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. Control display of chart using checkbox (form control)
    By Jonno1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-09-2016, 09:43 AM
  2. How to disable a Form Control Burron once Clicked?
    By vhache in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2015, 02:55 PM
  3. Use a Form Control Button to Verify Data & Display Message Box
    By thunder_279 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 01:43 PM
  4. How a combo box(form control) to display its list index value in Greek
    By Sotiris Kordas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 05:37 AM
  5. [SOLVED] Macro To Open A Hidden Worksheet When Button (Form Control) Is Clicked
    By obwales in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-25-2012, 12:55 AM
  6. [SOLVED] locked out by Information Rights Management notice
    By JMK in forum Excel General
    Replies: 0
    Last Post: 07-03-2006, 07:40 PM
  7. Problem: Control Toolbox Control resizes when clicked
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 03:05 AM

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