Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells using dialog box
Hey
I would like to be able to have a little popup dialogbox that allows me to click in Excel and select a range of cells by clicking the mouse on a cell and dragging into the cells I want to include into my range. Then after I release my mouse button, the actual range pops up in the dialogbox. For example I click a button and the dialog pop up. I click in Excel and drag from A3 to B20. When I release the mouse button, I would like for the popupbox textbox to show A3:B20. (This type of thing can be observed when creating a chart or pivot table.) How do I do this? Thanks Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells using dialog box
You will need to create a userform and place a label on that form. Then run
the test funtion which should be placed in one of the sheets... Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) UserForm1.Label1.Caption = Target.Address End Sub Sub test() UserForm1.Show False End Sub "Todd Huttenstine" wrote: Hey I would like to be able to have a little popup dialogbox that allows me to click in Excel and select a range of cells by clicking the mouse on a cell and dragging into the cells I want to include into my range. Then after I release my mouse button, the actual range pops up in the dialogbox. For example I click a button and the dialog pop up. I click in Excel and drag from A3 to B20. When I release the mouse button, I would like for the popupbox textbox to show A3:B20. (This type of thing can be observed when creating a chart or pivot table.) How do I do this? Thanks Todd Huttenstine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells using dialog box
Thanks
-----Original Message----- You will need to create a userform and place a label on that form. Then run the test funtion which should be placed in one of the sheets... Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) UserForm1.Label1.Caption = Target.Address End Sub Sub test() UserForm1.Show False End Sub "Todd Huttenstine" wrote: Hey I would like to be able to have a little popup dialogbox that allows me to click in Excel and select a range of cells by clicking the mouse on a cell and dragging into the cells I want to include into my range. Then after I release my mouse button, the actual range pops up in the dialogbox. For example I click a button and the dialog pop up. I click in Excel and drag from A3 to B20. When I release the mouse button, I would like for the popupbox textbox to show A3:B20. (This type of thing can be observed when creating a chart or pivot table.) How do I do this? Thanks Todd Huttenstine . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Cells using dialog box
Hi Todd
It I understand this right: Sub test() Dim R As Range On Error Resume Next Set R = Application.InputBox("Select a range:", _ "Todd says", Selection.Address, Type:=8) If R Is Nothing Then Exit Sub R.Font.Bold = True 'or whatever End Sub You can also make a userform with a RefEdit control on it for similar behavior. HTH. Best wishes Harald "Todd Huttenstine" skrev i melding ... Hey I would like to be able to have a little popup dialogbox that allows me to click in Excel and select a range of cells by clicking the mouse on a cell and dragging into the cells I want to include into my range. Then after I release my mouse button, the actual range pops up in the dialogbox. For example I click a button and the dialog pop up. I click in Excel and drag from A3 to B20. When I release the mouse button, I would like for the popupbox textbox to show A3:B20. (This type of thing can be observed when creating a chart or pivot table.) How do I do this? Thanks Todd Huttenstine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No Dialog Box when Pasting Cut Cells | New Users to Excel | |||
Format Cells Dialog Box | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
Selecting a file path in Excel VBA using FileOpen dialog | Excel Programming | |||
Format Cells dialog box | Excel Programming |