On Apr 24, 8:26*am, Mac wrote:
If only it were that simple ...:-D I need to do further processing on the
data in the selected rows; all I need is to somehow display this
stay-where-you-are sort of a 'dialog' and a way to to read that dynamically
changing selection as the user goes on clicking ...



"jlclyde" wrote:
On Apr 24, 6:37 am, Mac wrote:
Hi,

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways *(the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and the user will only click
the row headers to select an entire row at a time; now, what I want in the
dialog box to appear is the sum (or whatever, it doesn't matter for now) of
the number in the rows that are selected, that is - the user clicks once =
the dialog shows the number in the row clicked; the user Ctrl+clicks in
another row = the dialog box shows the sum of the numbers in both rows; the
user Ctrl+clicks one of the rows selected = the dialog box adjusts the sum
appropriately, ie subtracts from the sum the number in the row just
unselected;...
Is there a piece of code to show me how to create such dialog box and how to
have it 'track' such dynamically changing selection? Thank you!!!

There is a really cool trick that excel does. *Down in the bottom
right corner of excel it will say saomthing like Num. *Right click in
this area and you can have it sum your selection or average and other
functions. *Is this what you are looking to accomplish?
Jay- Hide quoted text -

- Show quoted text -

Mac,
You shoudl try what I suggested. Right click and change it to sum.
Now everythign that you ahve highlighted will be summed in this box.
If you want to do this VIA code, I am not sure how you woudl get a
object to float around and show you the sum. If you wanted it in a
specific cell or group of cells you coudl do a change event procedure
or something.
Jay