If the combobox is on the sheet itself, you just need to get the name of the
sheet they selected, something like
Private Sub ComboBox1_Change()
MsgBox ComboBox1.Text
End Sub

take combobox1.text and pass it into something to update the sheet. and
depending on what exactly you are updating
Sheets(combobox1.text).Select
Range("A1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Loopi" wrote:

I have a spreadsheet that automatically updates links to 12 monthly sheets
when opened. The user then selects a month of interest in a dropdown list and
views the desired information for the month selected. My problem is this a
networked version that can take a long time to update all 12 links upon
opening. I would like to stop the auto updating, which I know how to do, and
write a macro to update only the link corresponding to the month selected by
the user. The users could manually update the link but they are not
experienced users so I am creating the macro to simplify. I know how to write
a macro to update all links but I would like the macro to only update the
link to the month selected by a user. I am not a real good code guy but is
seems like I need to set a variable somehow pulling from a range that the
selected month exists, then find a way to incorporate this into the
updatelinks routine. Thanks for your time.