Afternoon all,
just wanted a few general tips and a point in the right direction for what i'd have to do to achieve the following.
I have 13 sheets, Jan - Dec then a Summary page. Each sheet shows sales figures for approx 500 stores. The summary page just adds these up for a YTD total - simples. To make things a bit 'sexier' i'd like to double click a value in my summary page and a graph to pop up with the trend for the year, so a bar graph with each months figures. I have a particular format of chart to use (pilfered from a colleagues worksheet!).
Whats the general gist. Would i be talking about a userform pop up for each one? Is this something which is just done through coding or some other bells and whistles needed?
Much appreciated.
CDH
I have a userform with a comandbutton that i am trying to use in 2 ways.
If other fields required data on the form, a single click of this button will enter the data.
If only one particular field requires data, i was going to doubleclick the button to enter the data.
All the code is done and will work fine, but it seems i can't use Commandbutton9_click and Commandbutton9_Dblclick. It doesn't like that.
Is there any way instead of trapping whether there has been a single or doubleclick of the button and then calling the code as required based on that result?
Any help or advice or alternatives most welcome.
Hi everyone
I need to be able to click or double click a cell and it will insert the time
Is this possible?
Thanks
Team,
I'm trying to get a single click to act like double click.
In a merged cell - I'd like to click anywhere on the merged cells
and have the entire contents highlighted; as would happen if I double clicked on the cell.
I'm currently trying to use this code:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'--merged cells are in columns 2 though 9
Dim lR As Long
Dim lC As Long
If Target.Cells.Count > 1 Then Exit Sub
'--------------------------------
lR = Target.Cells.Row
lC = Target.Cells.Column
If lC >= 2 And lC
I am trying to replicate Excel's built-in data validation with VBA code using a msgbox with OK and Retry buttons.
The part I'm struggling with is what happens when you hit the Retry button. The contents of the cell (that didn't meet some specified criteria) are completely selected within the cell.
I can acheive the same effect by manually double-clicking a cell to activate the cursor within the cell and then double to the cell contents to select the entire cell's contents.
How can I program a "double-double-click" in VBA code? Thanks for any help on this one.
Aaron
Hi,
I am urgently looking for a double click macro.
I need one which will format the fill of a row to red once double clicked?
x
Hi,
I dont suppose anyone knows why it is that when I format a column, I have to double click in the cell for it to work. For example, my column A looks like this:
A
12/2009
01/2007
06/2001
Even after formatting the cell to Custom->General->DD/MM/YYYY, it still does not change it unless I then double click into it. Thing is, I dont want to have to do this for 2000 cells.#
Argh...Please help!!
Sheet1 == Name, addr1, addr2, dob, mbr.status, xxx, yyy, DOLM
Want list of all names - aprox. 100-300 will attend
Select name to update or replace DOLM field
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column 1 Then Exit Sub
rspn = MsgBox("Update " & Target & "?", vbYesNo)
If rspn = vbYes Then Cells(Target.Row, 8) = Date
End Sub
This worked b4 but not now?????
I have a cell titled "income" and I would like to be able to double-click on the cell and a box pop-up with some information in it. I would like to avoid using data validation or notes. Also, would it be possible to add a next button to this for multiple "slides." Thanks
