Create a pop-up when a text box is selected

[terry16202]

I am trying to get a second text box to pop-up when a specific visible text box is selected. To better explain, I have a table on sheet 1:

Sheet 1 also contains the 5 visible text boxs with the names in column A. If I select TextBox60, I would like TextBox61 to appear or become visible. The table of names will grow. I have tried messing with simplified code but can't get it to work:

Private Sub Worksheet_Selection(ByVal target As String)

selected_textbox = Selection.Name

If Left(selected_textbox, 4) = "Text" Then

​

ActiveSheet.Shapes("TextBox 61").Visible = False
Else

​

ActiveSheet.Shapes("TextBox 61").Visible = True
End If
End Sub

Any suggestions would be greatly appreciated.

Thanks,
Mike

 

[terry16202]

Anyone??? I am still stumped.... I am starting to think it might not be possible.

 

[starl]

It's possible - but it's ugly.
Maybe I'm just too tired, but I can't figure out where you got that event.. it's not one as far as i remember.
Anyway - you probably should take a step back and look at this another way. WHY do you need so many textboxes?? Are they pretty much all the same? Is there a better solution to what you need?

 

[terry16202]

That was kind of what I thought. I created a fairly large flowchart using text boxes in excel because of the large workspace. I need the mobility of the text boxes vs. cells, so that I can easily rearrange if needed. I was looking to do what I described above, so I could add notes to a particular step in the flowchart that would appear only when you click on the box.... I think I can come up with a work around.... just won't be as pretty. :wink:

Thanks!

 

[starl]

Could you use cells if you didn't need to rearrange?? Could use have one sheet with all your text and use cell addresses to arrange your flow chart?
Then you could use comments for your "pop ups"
What version of Office are you using?

I am just so not a fan of putting controls on sheets - especially so many controls. Years of Excel bugs that would re-arrange those controls..

 

[tusharm]

What does a textbox mean to you? How do these textboxes relate to the data in column A?

Also, what is this worksheet_selection procedure? How does it get used?

I am trying to get a second text box to pop-up when a specific visible text box is selected. To better explain, I have a table on sheet 1:

Sheet 1 also contains the 5 visible text boxs with the names in column A. If I select TextBox60, I would like TextBox61 to appear or become visible. The table of names will grow. I have tried messing with simplified code but can't get it to work:

Private Sub Worksheet_Selection(ByVal target As String)

selected_textbox = Selection.Name

If Left(selected_textbox, 4) = "Text" Then

​

ActiveSheet.Shapes("TextBox 61").Visible = False
Else

​

ActiveSheet.Shapes("TextBox 61").Visible = True
End If
End Sub

Any suggestions would be greatly appreciated.

Thanks,
Mike