click

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

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

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

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

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

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

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.

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

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 ?

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

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", _...

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

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

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

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

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

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

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: \\192.168.0.6\Production\). So, I will have 2 Report.xlsm files, 1 in my local...

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

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