+ Reply to Thread
Results 1 to 5 of 5

Checkboxes in Userform

  1. 12-15-2010, 12:52 PM #1
    ABSTRAKTUS
    ABSTRAKTUS is offline
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Checkboxes in Userform

    Hi Gurus!

    I need your priceless help again. Here I have a workbook with 4 sheets in it. Every sheet is a database. Also I have created a userform with 4 checkboxes and some other stuff (textboxes, comboboxes etc.) Checkboxes represent shift. When filling userform, I want users to check the relevant checkbox and all values from txt and cmb save to the sheet regarding which checkbox has been checked. Example:

    If checkbox1 checked - all values go to sheet1, if checkbox 2 - values to sheet2 etc.

    Thoughts?

    Thanks a lot guys!
    Reply With QuoteRegister To Reply
  2. 12-15-2010, 01:30 PM #2
    snb
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Checkboxes in Userform 

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Last edited by snb; 12-15-2010 at 01:34 PM.

    Reply With QuoteRegister To Reply
  3. 12-15-2010, 01:51 PM #3
    ABSTRAKTUS
    ABSTRAKTUS is offline
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Checkboxes in Userform

    A little confusing... Here is my code to copy data to the database:
    Please Login or Register  to view this content.
    So for each of controls I have to assign your code or am I wrong?
    Last edited by romperstomper; 12-15-2010 at 06:58 PM. Reason: Add tags
    Reply With QuoteRegister To Reply
  4. 12-15-2010, 01:53 PM #4
    ABSTRAKTUS
    ABSTRAKTUS is offline
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Checkboxes in Userform

    Sorry it was Option Buttons, not checkboxes! My fault...
    Reply With QuoteRegister To Reply
  5. 12-15-2010, 04:13 PM #5
    snb
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Checkboxes in Userform 

    Please Login or Register  to view this content.
    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)

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