+ Reply to Thread
Results 1 to 3 of 3

If userform text box is not selected, do nothing on control click

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    If userform text box is not selected, do nothing on control click

    How can I tell the code to do nothing if any userform textbox is not selected?
    Or a message box to say nothing selected.

    FORM CALL
    Please Login or Register  to view this content.
    FORM CODE
    Please Login or Register  to view this content.

    CLASS MODULE named clsDelegate
    Please Login or Register  to view this content.

    CLASS MODULE NAMED clsEvents
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: If userform text box is not selected, do nothing on control click

    I guess you mean:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: If userform text box is not selected, do nothing on control click

    @rorya. Thanks it worked.

+ 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. [SOLVED] Select all text when i click in combobox (userform)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2017, 07:28 AM
  2. control tip text to show on top of userform
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2016, 04:51 PM
  3. [SOLVED] Excel UserForm. Click Button to open explorer and go to URL within a text box
    By stevefisher85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2016, 06:09 AM
  4. [SOLVED] Call userform control click event indirectly
    By ryan.wherry in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-26-2015, 11:42 AM
  5. [SOLVED] Userform: Double click to remove selected removes all items.
    By CO# in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2014, 10:29 AM
  6. Userform Calendar Double click control
    By danmarson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2013, 04:53 AM
  7. Double Click Text Box on a UserForm to Look-up Value in Another Tab
    By timtomm66 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2013, 06:33 AM

Tags for this Thread

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