+ Reply to Thread
Results 1 to 7 of 7

Using dim w/t a Userform

  1. 08-22-2019, 12:18 PM #1
    brentjohn
    brentjohn is offline
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    510

    Using dim w/t a Userform

    Greetings,
    I know I must be doing something wrong, but I cannot figure it out. I am trying to use the following within a Userform and it is not working.
    tbPath = ToggleButton Name
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-22-2019, 12:31 PM #2
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,072

    Re: Using dim w/t a Userform 

    Please Login or Register  to view this content.
    Why the extra red snippet
    Just extra work re-naming the toggle button then setting it to a variable...
    Must make use of...
    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 08-22-2019, 12:38 PM #3
    brentjohn
    brentjohn is offline
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    510

    Re: Using dim w/t a Userform

    sintek,
    Not sure as to why the extra "Click" was posted - it has been removed.
    How/where do I insert the...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-22-2019, 12:58 PM #4
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,072

    Re: Using dim w/t a Userform

    Replace all tbPath with above

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 08-22-2019, 01:05 PM #5
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,072
    I would just put the lot in a with statement...
    Reply With QuoteRegister To Reply
  6. 08-22-2019, 01:08 PM #6
    brentjohn
    brentjohn is offline
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    510

    Re: Using dim w/t a Userform

    sintek,
    Works GREAT!!!
    Thank you much!!!
    Reply With QuoteRegister To Reply
  7. 08-22-2019, 01:50 PM #7
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,072

    Re: Using dim w/t a Userform

    Glad I could help...Tx for rep +
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform inputs comparison with sheet cells and if true reset userform fields
    By aidan5800 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-08-2018, 04:51 PM
  2. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  3. [SOLVED] Excel 2007, Userform Textbox Date Format and Calendar Control Userform
    By riffology in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 06:18 PM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  5. [SOLVED] Changed userform combobox to listbox, unable to get userform to retrieve datasheet values
    By dragonabsurdum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2013, 01:38 PM
  6. [SOLVED] Open a userform from a userform, but preserve the info in the original userform
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2013, 02:38 PM
  7. userform is large.....how to use scrollbar of userform to show all of the userform
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2010, 04:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1