Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Update data in userform - checkbox

  1. #1

    Update data in userform - checkbox



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have Userform with checkboxes that apply to cell values. If result correct, then checkbox is ticked.

    I've pasted
    Code:
    VBmodeless
    in code to see the table and userform, but userform doesn't update my checkboxes when I fill cell values, only when I close and reopen userform. How can I update Userform without closing It ?

  2. #2
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    59
    Articles
    0
    can you attach a sample file ?

  3. #3
    Quote Originally Posted by patel View Post
    can you attach a sample file ?

    Here It is, Userforms are in B3 and B7, they both need to be updated while opened.
    Attached Files Attached Files

  4. #4
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    59
    Articles
    0
    set ShowModal property of the 2 userforms to false

  5. #5
    Quote Originally Posted by patel View Post
    set ShowModal property of the 2 userforms to false
    Done that, but nothing happens, data still updates only if I reopen Userforms - in Excel 2003, haven't try in Excel 2007 yet.

  6. #6
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    59
    Articles
    0
    put this code in class module of sheet1
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 5 Then UserForm1.UserForm_Initialize
    End Sub
    and change
    Code:
    Private Sub UserForm_Initialize()
    to
    Code:
    Public Sub UserForm_Initialize()

  7. #7
    Quote Originally Posted by patel View Post
    put this code in class module of sheet1
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 5 Then UserForm1.UserForm_Initialize
    End Sub
    and change
    Code:
    Private Sub UserForm_Initialize()
    to
    Code:
    Public Sub UserForm_Initialize()
    Patel, that doesn't work either. I've made refresh button instead and put code:

    Code:
    Unload Me 
    UserForm1.Show
    It works, but not quite as I want, so If you or anyone else has some other suggestions, I'd be more than happy

  8. #8
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    59
    Articles
    0
    try attached
    Attached Files Attached Files

  9. #9
    Quote Originally Posted by patel View Post
    try attached
    As I said, nothing. Thanks anyway

  10. #10
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    59
    Articles
    0
    it works on my Excel 2010, when I change cells in column E, the checkboxes change status

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •