clicking

Hi I closed all excel files. I opened a new one by clicking on excel icon. I go to VBA editor and I see some codes there? Why and from where they came? Thank you very much.

Hello all lovely people out there, can you please help me clicking buton inside table? https://imggmi.com" target="_blank"><img src="https://cdn1.imggmi.com/uploads/2019/10/11/e6b316b502a4be5bc2dc2a0aad272ef2-full.jpg" border="0"/>"]http://[/URL]

It always happen when I closed the excel and open it again by clicking the assigned macro

Hi, hope someone can help with this. I have listbox1 that has multiple items. I would like to select an item by double clicking the selected item and open a file. I have the path of where the file is so just need the code when double clicking the selection. thanks

Hi, I have a working formula in Excel that allows me tohyperlink to other cells within my worksheet by clicking a specific cell. Iwould like to assign that formula to a button because frankly, using a buttonlooks much more professional than clicking a cell. This is the formula that Iwant to...

How can I count the number of msgbox appeared between two events. The events probably are: 1. Opening userform 2. Clicking the submit button

First post to this forum. Familiar enough with computer stuff, but first time user of Excel. I'm doing this to help a friend. Excel 2010 on Windows 7 (Ultimate) running in a VirtualBox VM on Debian Linux Stretch My friend downloaded a free Excel add-in (in an 'xlam' file) which is to file...

Hello my combobox has 2 column counts and its items are added When i am clicking on the same it shows the values of 1st item. i dont understand why ? and not changing the value of idx as shown below infact clicking on each item should display in combobox text Private Sub ComboBox1_Click()...

I’m thinking of making a userform for my grass cutting business. I’m not entirely sure how to approach it yet but something like select a customers name & the relevant info fields are then shown. One thing I’m stuck with is some customers have repeat visits so maybe by clicking on a fields...

Good day all! I have trouble protecting my sheet's data. I would like to lock my sheet but keep the label alterable/unlock. I know how to do it for cells, but for the labels I can not do it.:mad: While clicking on the protect sheet, there is no case for the labels to tick. Thank you in...

Hello, in sheet 2 cells A3:A302 I have numbers ( 60001 to 60300) , which should remain untouched. when I click on A3 sheet 2 it should direct me to sheet 3 . and when clicking on Sheet 2 A4 it would take to sheet 4 and so on. clicking on Sheet 2 A5 takes me to sheet 5 clicking on Sheet 2 A6...

Hello,</SPAN></SPAN> Highlights different column on double clicking. </SPAN></SPAN> For example double clicking (highlight multicolumn) on cell N12-highlihght 2 columns C12:D42, on cell O12-highlihght 4 columns C12:F42, on cell P12-highlihght 6 columns C12:H42 </SPAN></SPAN> For example...

Hi folks, I'm trying to allow the users select a worksheet name by using the mouse to click on the worksheet tab. If I use... Dim sName as String sName = Application.InputBox("Enter the Sheet Name", Type:=2) ...I get "Excel found a problem with one or more formula references in this...

Allow me to explain. I am a doctoral candidate and my all my raw data will be in the "left most" sheet. I want to clean it in stages, with the data in each stage going into the next sheet. When my chairmen clicks into the sheet I want the explanation of what the stage is to pop up. I would...

Dear Sir, I Want to execute Micro by clicking Cell "A3" Containt. Can It Possibel.

Hi everyone, First I must say that this forum is awesome. Everybody wants to help! So to my question. Is it possible to create a macro that makes it possible to duplicate the activated sheet by clicking a cell (Something like a "hyperlink"). Is this possible to do? I would be grateful if...

I have a macro which opens a userform with a listbox. I execute this macro by clicking a shape in a worksheet. The problem is that sometimes when the userform pops up, the listbox catches the same mouse click from clicking the shape, and that selects an item on the list. What is the best way...

As standard new workbooks I create have 3 worksheets. If I want to add an additional sheet by clicking the + after the last sheet or by clicking insert it adds 3 new worksheets. Is there a way of only adding one at a time? I have experimented with restricting new workbooks to one worksheet but...

I want to duplicate a worksheeet (Tab) within a shared workbook? When I try it the conventional way by right clicking on the tab a message pops up that says it's not allowed in a shared workbook. Thanks.

Hi guys. I have a spread sheet with multiple options on there. Previously I had used hyperlinks to link to word documents for the shipping labels but people are clicking by mistake a making a right hash of things so I am now looking at adding VBA code where you would double click a set cell and...