Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
How do you do a range selection dialog like those many in Excel?
Hi all,
I want to select some range dynamically, including multiple selection, via showing a range selection dialog... Hopefully there are some dialog functions that I can use... How to do that in VBA? Thanks! |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
How do you do a range selection dialog like those many in Excel?
There is a RefEdit control for the toolbar, add it if you don't have it
already by selecting More Controls (hammer and wrench icon) and select RefEdit. You need to have a userform up to do this in VB, right click on your project and add Userform, the toolbox will appear. -- -John Please rate when your question is answered to help us and others know what is helpful. "LunaMoon" wrote: Hi all, I want to select some range dynamically, including multiple selection, via showing a range selection dialog... Hopefully there are some dialog functions that I can use... How to do that in VBA? Thanks! |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
How do you do a range selection dialog like those many in Excel?
Another way; this just uses an input box...
Copy the following into a standard code module and run the first one (you will need to correct for line wrap): Sub TESTIT() Dim sAddress As String sAddress = InputBoxRange MsgBox "The selection was: " & sAddress End Sub Public Function InputBoxRange() As String Dim rngResponse As Range Dim strMsg As String Dim intConfirm As Integer On Error Resume Next Do Set rngResponse = Application.InputBox("Type or select a range of cells:", "RANGE VALIDATION", Selection.Address, , , , , 8) If Err.Number < 0 Then Err.Clear: End rngResponse.Select intConfirm = MsgBox("Is the following selection correct?" & vbCr & vbCr & rngResponse.Address, vbQuestion + vbYesNo, "CONFIRM SELECTION") If intConfirm = 6 Then Exit Do 'YES Loop InputBoxRange = rngResponse.Address End Function "LunaMoon" wrote: Hi all, I want to select some range dynamically, including multiple selection, via showing a range selection dialog... Hopefully there are some dialog functions that I can use... How to do that in VBA? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dialog box selection type | Excel Discussion (Misc queries) | |||
How do you do a range selection dialog like those many in Excel? | Excel Discussion (Misc queries) | |||
The file association dialog won't allow selection of Excel | Setting up and Configuration of Excel | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Dialog Box Confirmation Selection | Excel Programming |