1. M

    Initiate command when userform's combo box is clicked

    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...
  2. H


    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)...
  3. S

    anchoring comments/notes active vs non-active cells

    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...
  4. H

    Formula Wont Work When Sheet is Lock By Password

    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...
  5. T

    Saving Workbook as .pdf with specific path and filename

    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...
  6. J

    VBA Workbook number

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

    VBA Workbooks.activate default

    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...
  8. J

    Count # of Times Cell is Activated

    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...
  9. Johnny C

    Why can you only access a shape properties when the sheet with the shape on is activated?

    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...
  10. N

    Perform for-each and find actions in other not active workbooks

    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...
  11. B

    Snap to Grid/Shape

    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?
  12. S

    VBA change already activated (displayed) userform's position

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

    How do I detect if a certain table column has a certain filter activated?

    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...
  14. A

    Go to Worksheet with Name Corresponding to Cell Value

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back