Controls and VBA help
Controls and VBA help
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Controls and VBA help

  1. #1
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Good morning, Excel world!

    I have two options buttons and one text box. I want the text box to be hidden until Button2 is selected. I then want it to become visible and enabled for input.

    Also, I want a message box to appear when 8 specific cells have been filled in.

    Does anyone have any code that will guide me?

    Thanks,
    Shirlene

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah sure, firstly you need to go to the textbox's properties bar and go to Visible, and change it from True to False.

    The code you want to put into the optionbutton's change event is:

    if optionbutton2.value = true then
    textbox1.visible=true
    else
    textbox1.visible=false
    end if

    Hope this helps

    Audiojoe
    Ebony and Ivory, live together in perfect harmony

    [ This Message was edited by: Audiojoe on 2002-04-18 05:26 ]

  3. #3
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    AudioJoe, thanks for your help on the first topic. I was coding the optionbutton2 on click, not change. Now it works fine.

    How about the message box problem. Any ideas? Anyone else want to provide some input?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, had to shoot off for a while. What cells will be used? And what will you be putting in them?

  5. #5
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not sure exactly what cells but let's say A1, A3, A5, A7, A9, A11, A13, A15. They will contain variable text data.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    So could they be anywhere on the spreadsheet, or is it in the same row, or column, or in a certain range?

  7. #7
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am unsure of what the cells are but they will always be the same 8 cells, once the sheet is created. I need a message box to pop up when all 8 cells have data. It doesn't matter what we use as test data.

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, well I've sort of designed a little test one for you. The way I've done it is a little unorthodox. I'll mail it to you

    Audiojoe

    I was looking for a job and then I found a job. But heaven knows I'm miserable now

  9. #9
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, AudioJoe, for your help. I will look for the file to arrive in my email.

  10. #10
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I was making it way too hard. Your way is so simple! Thanks so much. I really appreciate your help.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com