activated

Is there a way to initiate commands when a combobox is activated? In other words, if the cursor does not appear in a combobox, but then the combobox is clicked and the cursor populates the combobox, can I have commands run? I am not looking for ComboBox_Change, I am more looking for something...

I need some help with combobox's it's my first time Using those on Userform. 1. Combobox1 should look at Column "E" for Cell with "1" to "7" ---> "1" from E325:E452 (it's for the first 128 Players in Cupsystem)...

I have the following which seems to reset comment/note boxes only when the red indicator is hovered over: Sub ResetComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Top = cmt.Parent.Top + 5 cmt.Shape.Left = _ cmt.Parent.Offset(0, 1).Left + 5 Next End Sub However...

Ive got lots of those 2 Code But different from Colom ad Row's The Codes WORK as they Should BUT not when i make sheetprotection Now a Description of what they Do. Firstcode line: cell L215 and L221 is activated by Enter 1 or 2 in cell when activated a VBA code set a Timestamp Next to the...

I have a workbook template that saves to a specific path and filename when the save button is activated. I'd like it to also save it as a .pdf to a different path with the same filename when the save button is activated. I hope that makes sense and I've posted this correctly... The existing...

I have workbooks open. Want to write a variable which identifies which number the current activated workbook is?

Created a macro to define a variable for the current activated workbook. Then I open another file. And then I want to activate the first workbook. The code defaults when cworkbook is asked to be activated in the end of the code: Sub This_Workbook() 'Reference to active work book Dim...

I currently have a workbook that is locked where users can tab through and enter data. I am trying to get a count every time Cell G5 is activated (either through tabbing or clicking). I currently am using this code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...

Just idly curious. I can't access a shapes properties unless the sheet is activated. I'm guessing the process of activating the sheet loads the sheet shapes into accessible memory, but why? Are the sheet's shapes and properties stored in an abbreviated form that is only expanded to accessible...

I have the following problem: I have Wbk1.xlsx activated and I want some code to be executed on Wbk2.xlsx : For Each rg1 In Workbooks("Wbk2.xlsx").Worksheets("Sheet1").Range(Cells(nPostingDate_Row, 1), Cells(nPostingDate_Row, nFinal_Column)) nPostingDate_Row is 12 in the example and...

Greetings, When I click on the "Snap to Grid" & "Snap to Shape" all works good, then I save the workbook. However, when I open the workbook, both snaps are not activated. What am i doing wrong?

Hi all, Is there a way to change already activated (displayed) UserForm's position on the screen? Thank you in advance

Hello everyone, I have a rather complex question... which is the following: I have a table column header called "Column1" which has the following filter activated through VBA: ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=.ListColumns("Column1").Index...

Morning All; I am in need of some assistance in creating a hyperlink or a Worksheet_BeforeDoubleClick sub that will go to a worksheet with a name that is the same as the value of a referenced cell. For example: <tbody> A1 B1 A2 B2 </tbody> Double clicking or having a hyperlink in a cell in...