Hey all.
I've written a few macros to make my office work faster, but I'm stuck on this one.
I need to be able to select two separate pieces of text manually, using the CTRL key, and then run a macro that can handle these two pieces of text.
Ultimately I'm dropping them into a database.
The database part is all working.
Where I'm stuck is on dealing with the selection in the macro.
For example, if I select the word "hello" and then later down the document select "world" while holding down CTRL, the two items are both selected.
But if I write a quick macro: Msgbox(Selection.Text)
the output is "world"
I need a way to get at both selected pieces.
Anybody?
thanks.




Reply With Quote