click event

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

Hello there, I tried to ask a very complicated question not to long ago, and I may have screwed up what I was trying to figure out. So here goes a second try in a different way. My question is such. Can you click on a cell populated with let's say a word or basic string of numbers (like a part...

Hi, Please help me with VBA code to capture the current date when a particular cell in excel is clicked or copied. like doubleclick or rightclick event. <tbody> Order# Status Comments Last access date AD1212462 Completed Login success </tbody>

I have 2 option buttons in a frame on a user form. When one of them is clicked (changes), I want to trigger code that makes the visible property of a textbox (which is not in the frame) false, that is, hide the text box. I want to do this without having to click a command button first, through...

Good day all, Struggling with this 'click' functionality. I have seen some instances where vba can be used to call a click function to occur. I am currently struggling with it. Mimicing lines of code is not working and I am curious if this is due to a naming issue, or that I have too much...

I'm trying to get an event to fire when the current tab is clicked at the bottom of the workbook. I know there's the event that fires when a sheet that is not the active sheet is clicked and thus becomes the active sheet, but I need to have my event fire when you click the tab of the currently...

Hi All VB experts, Need your help, how can I get the selected row and coloumn value when I click the list view ? For example : I have below list view with first coloumn as a header : Pers No Detail name Department 32998001 Alex FG Marketing...

I have a VBA userform with a grid of numbers, each of which needs its own "click" action. For example: [0 1 1 4 0 1 0] [2 0 0 0 0 2 0] These numbers are updated through other VBA functions. How can I create click actions for each of these numbers? Right now this data is created as lables on...

Super simple question - Is it possible to get the value of a selected listbox item once it's clicked? I'm not having any luck. I'm trying: Sub lstMyListbox_Click() z = msgbox("you selected: " & activesheet.lstMyListbox.value & " from the list.", vbOkOnly, "Info") End Sub This... doesn't do...

Hello. I know this could be a widely discussed question but I deeply looked for an answer and wasn't able to find the best one. I am trying to make a code which fill the value "x" to a range of cells (by columns), based on a single click in one other cell. Moreover i want that one another click...

I have an Excel 2010 workbook with many worksheets using hundreds of Form Control (not ActiveX) checkboxes. I need a bit of VBA to change Checkbox background color of each checkbox whenever the user checks the box. I assume this needs to be a click event? I don't even know the Checkbox property...

hellow geeks, Im traying to write some code(in vba) whice will responde to a user click on a command button whice belongs to MultiPage ActiveX control embedded on a Worksheet in excel. i cant find the way to do so. any suggestions? nadav

This problem has been driving me nuts for the last week. In Excel 2007. We have a userform with a bunch of controls. There are two pairs of combo boxes: SI & STEP are the first pair and PLAN & TASK are the second pair. By pair I mean the user selects an item in the 1st combobox and the 2nd is...

Hi I have a userform that has one combobox at the top created manually. When the userform is opened, the user select an option in the combobox (these options are taken from a range on 1 worksheet). From the selection of the combobox, I use the comboxbox's change event to create and display 5...

I am using excel 2003. I would like to double click on the form title bar to shrink the form to only show title bar. Double click again will restore the original size. Any idea with Windows API? I searched web and tried but it is not working. Thanks a lot.