linking a list item or text item in a user form to a worksheet

**ravergirl7216** · 07-30-2010, 09:28 PM

I'm looking to find a way to link a worksheet to a list item in a list box or a item in a text box. The list box or text bow will have multiple items that each need to link to other worksheets. This list box or text box is being used within a user form. From what i understand, using the rowsource property of the list box will not allow me to use the addItem property. I'd be willing to use either a text box or list box for this.Thanks so much for any help you can give.

**royUK** · 07-31-2010, 03:17 AM

Not sure what you mean. Try attaching an example & a clearer explanation

**Help_Excel** · 07-31-2010, 03:25 AM

I created an example of what I think you are shooting for and placed it at

http://www.HelpExcel.com/ExcelForum/LinkLB.xlsm

**foxguy** · 07-31-2010, 11:53 PM

Hi ravergirl7216;

What do you mean by "linked to a worksheet"? Do you mean you want a list of all the worksheets in the workbook? Do you mean that when you select an item in the Listbox that the sheet it is linked to will be activated? Or what?

What happens when you select an item in the Listbox?

**ravergirl7216** · 08-01-2010, 04:41 PM

I have a list box that has items in it. I want those items inthe list box individually to link to a worksheet within a workbook. I want the user form where the listbox resides to close and open up a worksheet.

**foxguy** · 08-01-2010, 07:16 PM

Hi ravergirl7216;

OK, to make sure I'm on the same page with you. You want a Listbox with all the sheet names listed, and when you select one of the sheets listed in the Listbox you want the userform to close and Activate the sheet selected in the Listbox.

Please Login or Register  to view this content.

**ravergirl7216** · 08-01-2010, 09:57 PM

sorry. I'm trying to be clear about what I need. I don't want to post the workbook because it may get confusing but,.... I think we're getting closer. I have a user form that, after using option buttons, delivers results to a text box (which was a list box earlier) and these results (it may be one or three items) must "each individually" link to a worksheet when you click or select it. I've gotten code that links the textbox itself to a worksheet. but what i need is the code to link what is inside the text box to a worksheet. So if the text box has apple, it would link to a worksheet named apple, and if orange was in the text box in would link to a worksheet called orange. When you click on apple in the listbox, it would go to it;s corresponding worksheet. Maybe I'm using the wrong box. Maybe I should switch to a combo box?

**foxguy** · 08-03-2010, 03:42 AM

Hi ravergirl7216;

Try this:

Sub Listbox1_Click()
Dim sh As Worksheet

On Error Resume Next
Set sh = Worksheets(Listbox1.Value)
On Error Goto 0

If Not sh Is Nothing Then
sh.Activate
End If
End Sub

**foxguy** · 08-03-2010, 03:43 AM

Hi ravergirl7216;

Try this:

Please Login or Register  to view this content.

linking a list item or text item in a user form to a worksheet

LinkBack

Thread Tools

Rate This Thread

Display

linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Re: linking a list item or text item in a user form to a worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions