Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VBA Code User Range Selection

9 views
Skip to first unread message

jimbo

unread,
Jan 4, 2010, 5:45:01 AM1/4/10
to
I have a current VBA and I would like to extend it to do the following after
the last command:-
allow a user to select a un pretermined range for deletion (could be any
number of coumns and rows) and for the macro to delete that range and either
restart the macro to continue with it's next command or alternatively to stop
via perhaps a message box instruction for the user .

--
hopalong

Mike H

unread,
Jan 4, 2010, 5:55:01 AM1/4/10
to
Hi,

Try this, when the input box pops up simply drag to select a range

Set deleterange = Application.InputBox(prompt:="Select a range of cells",
Type:=8)

Mike

jimbo

unread,
Jan 4, 2010, 6:50:01 AM1/4/10
to
Mike hi thanks for replying. Your suggestion works fine up to displaying a
message box and allows the user to select the range. However if the user
selects OK in the message box is does not delete the selected range. Can you
help further?

Many thanks
--
hopalong

Mike H

unread,
Jan 4, 2010, 7:13:01 AM1/4/10
to
Hi,

Like this

Set DeleteRange = Application.InputBox(prompt:="Select a range of cells",
Type:=8)
DeleteRange.ClearContents

Mike

jimbo

unread,
Jan 4, 2010, 8:02:01 AM1/4/10
to
Mike thanks for your support works great.

Chip Pearson

unread,
Jan 4, 2010, 9:31:43 PM1/4/10
to

> range for deletion
Be careful when using the word "delete". Strictly speaking, it means
to remove the range from the worksheet and shifting the appropriate
rows and columns upwards and to the left. If you merely want to remove
the content of the cells, use the term "clear".

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

0 new messages