Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select cell
is there any way i can moniter the next cellwhich is
selected ? It occurs inthe midle of a macro and the user needs to select a cell by clicking on it, and the value of that is used in the rest of the macro. this can either be done with a vba macro or a userform but im guessing the code will all b the same. Thank you for youre help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select cell
Hi David;
One way is to use a call for an Input Box and then declare the type to 8. That will force the user to return a range that you can then use. Thanks, Greg -----Original Message----- is there any way i can moniter the next cellwhich is selected ? It occurs inthe midle of a macro and the user needs to select a cell by clicking on it, and the value of that is used in the rest of the macro. this can either be done with a vba macro or a userform but im guessing the code will all b the same. Thank you for youre help . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select cell
Actually, the Excel inputbox supports the type 8 syntax
Sub SelectRange() Dim rng As Range On Error Resume Next Set rng = Application.InputBox("Select cell with you mouse", Type:=8) On Error GoTo 0 If rng Is Nothing Then MsgBox "You clicked cancel; hit OK/enter to exit macro" Exit Sub End If MsgBox "Range selected is " & rng.Address(0, 0, , True) End Sub -- Regards, Tom Ogilvy "GJones" wrote in message ... Hi David; One way is to use a call for an Input Box and then declare the type to 8. That will force the user to return a range that you can then use. Thanks, Greg -----Original Message----- is there any way i can moniter the next cellwhich is selected ? It occurs inthe midle of a macro and the user needs to select a cell by clicking on it, and the value of that is used in the rest of the macro. this can either be done with a vba macro or a userform but im guessing the code will all b the same. Thank you for youre help . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
select cell
i'm not very good at these things, but a RefEdit control would work i
think - especially if you need to navigate about the workbook when deciding which cell needs selecting (which could go onto your userform if you have one) "divid wells" wrote in message ... is there any way i can moniter the next cellwhich is selected ? It occurs inthe midle of a macro and the user needs to select a cell by clicking on it, and the value of that is used in the rest of the macro. this can either be done with a vba macro or a userform but im guessing the code will all b the same. Thank you for youre help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |