click

how can i use the right click button to select a value in a listbox?

Hi, I have like 3-4 paragraphs of text in each cell, I would like to display only the first line (keep 12.75 row height) and if i click on the cell, to expand to show the full text. Like a "read more" on the cell itself Thank you very much.

I have the following vba code in a worksheet that when you double click on say the 5th row under the 4th column (D) it deletes everything in that row from the 3rd column (C) to the 1st column (A) and then cuts and pastes the person’s name in the 1st column (A) onto another sheet. Works...

Book1BC1Start2Vanguard01-Feb-19IndexCell FormulasCellFormulaC2=Vanguard!C2 The formula is pointing to a sheet whose name is in the first column. How can I incorporate >> B2 into the formula in C2? so that I can click and drag the formula down

Assuming I have two codes, how can I wrap my code to detect if Enter key was pressed or a mouse click? So, if it is enter key it should run one code, if mouse click it should run another code

Hi All, First post as pretty competant on excel (for my needs) and manage to fnd answers to most things online or trial and error. However I have decided to move into the light and try my hand at VBA :eek2::eek2: and seem to have hit a snag early on with the Help function which I am likely to...

Hi guys, I currently have a sheet with a column that has different filterable criteria (eg Education, How to, Gaming, Style, Film) I recorded a macro to filter by the criteria 'Film' - however I dont know how to make it so that if I make another macro for 'Gaming', it will not deselect...

Am running Excel 2016 (64 bit) on 64 bit Windows 10 machine. When a called macro changes to view a worksheet with Panes set, most times the keyboard arrows will not change the view. Sometimes they move the cursor off the page, sometimes the cursor is non-responsive. Also, cannot mouse click...

If I use Shift+F10 for any selected FormControl/ActiveXControl/Shape, the correct context menu appears. But if I right click the object, I get a menu that reads : Move Here Copy Here Cancel Anyone know how to fix this?

Hi, I am requesting a file to be downloaded from a website (using Internet Explorer). I get a pop up that asks "Do you want to open or save XXXXX.xls from webpage". Is it possible to use VB to select 'Open' on this window? When I right click over this window (the above question) I do not get...

Hi, I have managed to get on to a webpage through some basic script. On that webpage there are a number of Hyperlinks. I need to identify the appropriate Hyperlink (in the below case it would be where the 'label' is "S-C-BSS-1" and then click it. Is this doable? If so...how? Element...

HelloTeam, My name is prathap, i need one help in offset formula. I have made a dropdown list, when i click on month i get month detail in the Column But i need the data in the right side of the sheet. When i click on the month i should get the month details in row wise. Need your support in...

Afternoon, For some reason some of my drop downs stopped working. I am now cleaning up the named manager list & these are now starting to work correctly. In the page that opens up is there a way to click on a NAME as excel tell you on what sheet it is connected with. Name i say name this is the...

I want to double click on a row, application.workbook.worksheet(1).range ("A1"). When I double click on it it shows a pop out a userform Thank you in advance

Hello everyone, So I have a macro called Duplication I wrote and I want to add it from the right click menu with the caption Dupliquer. I have found this code which allows it when I right click on a cell : Private Sub Workbook_Deactivate() On Error Resume Next With Application...

Good Day Ma'am's and Sir's I am currently trying to make a working system for sales and inventory. I need some help coding for which i have a userform which has 1button and 1textbox, which when you click the button the textbox display a number 1 value, and every time i will click the button the...

Hello When I try to copy a sheet I get the following error, which no matter what I click, does not go away (it actually generates tons of such messages with different name) i.ibb.co/BwffP3p/Capture.png Any idea please?

I typically use Application.Quit with a command button to quit out of excel in my user form. However, when I use this line of code and go to click to start on my program again, it acts all finicky as it loads. My program starts up best when I click the x button in the top right corner. Is there...

Hello, I want to create a data model based using two Excel workbooks, then I want to save the data model and use it in other workbooks. Basically, I want to be able to add measures, columns, tables, relationships, etc. in the future and have all my workbooks using that data model reflect the...

Hello! In columns B2:B20 I have the Names of all the other sheets in the workbook and each sheet has information in it. What I want to be able to do is click on, let's say B4 and it references the appropriate Sheet name and pulls that data range to L2 and continue that process for each B:B...