1. R

    2 macros (click a button) to insert certain text.

    I need 2 macros, one for a button when clicked to insert the text "NO", a second macro for a button when clicked to insert the text "YES". Both in range "B7:B200". Meaning if I click the button "NO", it will insert the text "NO" in first cell from range "B7:B200", meaning B7. After that if I...
  2. B

    How to deselect and fire a click event for images laid dynamically on a sheet

    Hi all, I have a program that inserts various square images onto the same size cells, on one particular sheet. From the code on a form, I want to disable all the images, to remove the grab points thus obviously preventing them from being moved, resized, etc. I also want to be able to click...
  3. K

    changing properties of command button

    many sources mention that when i add a control button from form controls into worksheet and right click on it, there should be option for properties from which i could change font, color , name etc.. but unfortunately when i do right click only options i see are: cut, copy, edit text, grouping...
  4. K

    Stop column data from moving

    Hello, So i'm trying to build a macro-updating document register. So column A = the full URL of the file location (input via macro - see below) Column B uses the following formula =LEFT(A2, FIND(CHAR(1), SUBSTITUTE(A2, "\", CHAR(1), LEN(A2)-LEN(SUBSTITUTE(A2, "\", ""))))-1) to find the...
  5. R

    Need help with VB code

    Hi All Michael M (thank you) wrote the original code for me and I'm trying to make a change I want to replace a deleted formula in column C when I double click in a cell. (See formula below) If Not Intersect(Target, Range("c:c")) Is Nothing Then Target.Formula = "=IF(BS$2=""Fixture...
  6. D

    Right Click Sheet Tab

    Hi, how can I hide the 'right click' options on a Worksheet Tab (not the Worksheet Cells) pls... I have a Worksheet that I lock with VBA (password) and I dont want users to be able to unlock hte Sheet through the 'right click' option, eg: Insert / Delete / Rename, etc
  7. L

    short cut for custom formatting

    Hi I want to Right click on group of cells --> Format Cell --> Custom --> [h]:mm So it is 3-4 click and I want to do that alot. Can I create a short cut to do these 3-4 steps in one click for example. Or Can I create a link in QAT area. Thank you very much.
  8. D

    Add multiple Macros to single click Command Button

    Hi all, I want to reset both my data validation dropdowns and manual entry cells with a single click of the Command Button. I already have the code for the dropdowns from a previous thread, what Macro/VBA should I enter to reset all manual entry cells to blank, and how do I combine the two to a...
  9. Z

    Image Click event

    Hello People, I'm trying to figure out a code which perform this : clicking on a image to open a certain form. I tried using this DoCmd.OpenForm "NameOfForm", , , "Image1=" & Image where Image 1 is the name of the image that i want to click on to open the form. any ideas ?
  10. L

    converting time to text and istext() question

    Hi I entered 1:00 and then 2:00 in cells B2 and B3, then in B4, I used = sum(B2,B3). <colgroup><col><col><col></colgroup><tbody> istext() time1 1:00 FALSE time2 2:00 FALSE total 3:00 </tbody> so far so good, then I highlight cells B2 and B3 and changed the format to "Text"...
  11. gheyman

    Access: Modify VBA code from an On Open to On Click

    I have code that I successfully run for one of my forms "On Open". I am trying to modify this for another form where the code is run when I click a button on the form Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler If Nz(DLookup("UserName", "tbl_Users", _...
  12. A

    Relative Referencing 101 Problems

    Hello, I am trying to learn relative referencing for excel macros, and I am having embarassing problems. I tried setting up a very simple sheet like so: <tbody> 1 1 5 1 2 1 5 2 3 3 2 3 3 </tbody> The first column starts in cell A1...
  13. P

    How to click on download button tableau dashboard webpage using excel vba

    I'm trying to click on button using element by classname tag name but no success
  14. P

    VBA: Following Hyperlink that's linked to Sharepoint?

    I've got a list of Hyperlinks, that are all files on a sharepoint site. When I click on one, it opens Microsoft Edge and at the bottom asks if I want to open the file. When I click "Open", the file then opens in the appropriate desktop app. I'm wondering if there is a way around Microsoft Edge...
  15. D

    Opening and Repairing Excel file using VBA

    I'm trying to automate the processing of several files, and several of the files throw up the message: "We found a problem with some content in 'ThisFile.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes." In order to get around this...
  16. D

    Trying to put a counter into a form

    Hi all, I'm trying to create a form to pop up when I click on a specific cell which i'm able to count within. I can code for the form to pop up when i click on a certain cell but it is what to do within the form and coding that. I would like there to be a box with numbers in. Next to that i...
  17. J

    Toggle filter on/off using VBA

    I have some pretty simple code that just isn't working... Basically, I want to create a button at the head of a column to toggle a filter on and off. So, if I click the button when the filter isn't applied, it applies the filter; if I click the button when it is applied, the filter is removed...
  18. Y

    Create Copy File/Workbook When Click Save (VBA)

    Hi dear, I have a workbook (example: Report.xlsm) in my local computer. In this workbook, I want to run a vba code to create a copy every time I click the save button to certain directory in my server (example: \\\Production\). So, I will have 2 Report.xlsm files, 1 in my local...
  19. N

    View active cell value in status bar

    I think I might be going mad. I'm sure that in my previous version in Excel for Mac (2008) I could view the value of an active cell in the status bar. Since upgrading to Excel 365 I can no longer see this info in the status bar. For the sake of my sanity, will someone please help me?:confused...
  20. K

    Copy using active cell with VBA

    I would like to click on a cell then run a macro that would copy the cell to the left and 65 more cells below it to the active cell and the 65 below it. Anyone think of a good trick to do this? Basicly I want to click in cell N20 and have a macro that would copy M20:M85 into N20:N85, but I want...

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