UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Code Fires When Worksheet Activates - Not A "form" Issue, Office 2013    
 
   
bakersburg9
post Dec 7 2017, 04:32 PM
Post#1



Posts: 4,956
Joined: 2-November 04
From: Downey, CA


I am working with 2 workbooks, and one has two tabs (worksheets) - I want my code (which is just selecting a single cell range) to run when I activate the worksheet - If I have to hard-code it, that's great, because the tab names don't change - everything I found when I searched the 'net is for FORMS in Excel - I found this, and tweeked it, but no go...

CODE
Private Sub Worksheet_Activate()
ComboBox1.Activate
End Sub
I tried replacing the combo box reference, but it didn't work - like I said, if I have to hard-code the reference to the particular workbook, that would be even better...

... any help would be greatly appreciated . . .
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 05:08 PM