click

Good Afternoon, I am trying to make some changes to an old work book. It has some buttons that are slightly different to anything I have come across before. I am used to buttons that have a macro assigned to them, however these buttons are all triggered by cmd_Click events on the work sheets...

Hi I have a cell D4 which has value = 40:03:28 The value is aligned to the right side of the cell, which gives me an impression it is a number, right? When I one click (select) that cell. I see the following: cell value = 40:03:28 Formula bar = 40:03:28 Home tab-->Number group --> I see...

Hi there! I have a program that I'm trying to write that displays a date in a cell based on whether a user clicks on a specific cell. Here are a few notes: The date is formatted as YYYMMDD A4 - Contains the first half of the date (ex YYYYMM) M4 - Displays the final date in YYMMMDD format F/G5...

Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that...

Hi I want to ask a question to the user and give 3 choices answers. Q) What is the color of the sky? [x] blue [] red [] green C1 = correct If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following =if(B1=true, "Correct", " wrong")...

Hi All, I am looking for VBA code where following steps areperformed: Open website https://www.abs.gov.au/Price-Indexes-and-Inflation Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...

Hi. Is there a good way to make it so that if i click a button, the code will check if a spesific cell has had any values in the last 10 times (10 is just an example), and if it hasent, a error message /msgbox will appear? Example. Lets say A1 is the cell i want to check, and a button with...

<table width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody><tr> <td style="width: 1%;"> <img alt="" src="/an/919858511/p/Ariba/hdr_Ariba_Discovery_2x.png" height="30" border="0"> </td> <td style="padding:4px 20px 0px...

Good evening, I'm posting a long Pivot Table from Excel to Outlook. I copy the Pivot table in Excel and go to Outlook and click on Paste, then click Paste Special, then I select Microsoft Excel Worksheet Object, then Ok. Only half of the Pivot Table is posted to Outlook. Help, what am I doing...

Hi All, I have a excel template where I have 8 shapes created as button and assigned a macro to each shape. Is there a option to disable the Shapes where the users are unable to click the shapes to run the macro. For example: I have a shapes with names Login and Logout. When the excel is...

Hi gurus in the sky I use form control buttons to make life easy for my users. I want to disable a right click totally. I have discovered how to disable the "cut, copy, paste etc" menu by pasting into ThisWorkbook Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target...

I have a regular textbox (Shape, not an active x textbox) that needs to have the text "Please type notes here" if it doesn't have anything in it. I also need the text to disappear when you click in it so it is ready to type into. Could someone help me with the vba code please?

Since I'm not that well versed in VBA, unlike most on this forum, I was hoping someone could answer a quick question regarding "Sub ComboBox1_Click()". I thought this was a mouse click event, but as I seem to be finding out, it is also a key click event. Is this correct? I'm wondering...

Hello I have 5 files. Each with 5 worksheets. For each file am trying to consolidate 5 work sheets into one file using Power Query - so I land up with 5 files that each have one worksheet. Worksheet names are AUG_DATA, SEP_DATA, OCT_DATA, NOV_DATA, DEC_DATA. I am trying to consolidate 5...

I have a listbox with code that runs after user makes a selection (clicks item). It's a Form Control (vs. ActiveX type). Right now, while the code runs (takes about 5 seconds to complete), user can immediately click another item on list and listbox selection changes (though click event doesn't...

https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=BpSibC I am trying to do a SUMIFS formula calculating the sales column if the country equals australia, india and china (actual data has more countries) =sum(sumifs(B2:B4,{ If I try to click on the cell to reference it, Excel doesn't let us...

Ok guys i know the short cut for starting and stopping a recording macro is Alt+T+M+R. My problem is im wanting a macro that will insert a new Row in my table, in form view. (Select anywhere on the table, click on insert at the top ribbon, then click on "Form" on the top right ribbion, then...

I use this on a number of large files (in 2003 compatibility mode because it is much faster) and when I click Data - Advanced it always comes up with the "Filter the list in place" and every time I must click "Copy to another location" before OK. Is there any way to make Copy to another...

Hi all. I hope you can help me as I am having a bad, bad day I was editing a long macro earlier in VB editor and when I returned to it, my macros have all disappeared. The PERSONAL.XLSB file is still visible in C:\Users\tt*******\AppData\Roaming\Microsoft\Excel\XLSTART which I hope is a...

I have two columns that the user needs to update. One column is a checkbox (actually a wingding font) and the other is a cell with free data. I want them to be able to double click on the checkbox cell but not enter any data. I want them to be able to click on free data cell and enter data. I...