+ Reply to Thread
Results 1 to 7 of 7

Clearing textboxes, checkboxes and comboboxes on userform

  1. #1
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    209

    Clearing textboxes, checkboxes and comboboxes on userform

    Hello I have some textboxes and some checkboxes i can seem to clear them but there is 1 textbox that i would like to to be cleared (Called tbLogged). Also not sure if the combobox is correct?

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Re: Clearing textboxes, checkboxes and comboboxes on userform

    Can you please share your workbook?

  3. #3
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    209

    Re: Clearing textboxes, checkboxes and comboboxes on userform

    I have attached my file

    Regards,

    Chris
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Re: Clearing textboxes, checkboxes and comboboxes on userform

    Chris,

    If the default of the Textboxes and the checkboxes is nothing then try only:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    209

    Re: Clearing textboxes, checkboxes and comboboxes on userform

    That doesn't clear the cells in the worksheet. The idea is to be able to reuse the form to enter the data and the worksheet to be printed off.

    I thought it did work but not iff you leave the data in the cells of the worksheet.
    But thanks for a simple solution for the userform

  6. #6
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Re: Clearing textboxes, checkboxes and comboboxes on userform

    Try this Chris.

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    209

    Re: Clearing textboxes, checkboxes and comboboxes on userform

    No didn't work so I tried

    Please Login or Register  to view this content.
    That now work thanks for your help

+ 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] Populating userform textboxes basis of results from 2 userform comboboxes
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2017, 10:26 AM
  2. [SOLVED] Code for all TextBoxes; Comboboxes and CheckBoxes in an UserForm
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2016, 05:19 AM
  3. [SOLVED] Userform Command Button to add more comboboxes and textboxes at the same time
    By charscribbles in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-29-2014, 12:35 PM
  4. UserForm, TextBoxes/ComboBoxes & Typing Control Error
    By wipMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2013, 07:52 AM
  5. userform with 3 comboboxes and textboxes send to sheet
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2013, 03:15 PM
  6. Data Validation for all TextBoxes and Comboboxes in Userform
    By singhabhijitkumar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2010, 05:48 PM
  7. How to empty all comboboxes and textboxes in a userform
    By LoveCandle in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-06-2009, 02:28 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