Hi,
Is there anyway to interupt a macro at a certain point to allow the user to select a cell and then restart when a cell is selected?
thanks in advance.
Hi,
Is there anyway to interupt a macro at a certain point to allow the user to select a cell and then restart when a cell is selected?
thanks in advance.
Last edited by tenk283; 09-26-2010 at 12:51 AM.
Put in a message box with a simple message such as "Select a cell and press OK"
the macro will then wait until the OK button is pressed.
Ben Van Johnson
Hi tenk283, v\
you could use ..
![]()
option explicit sub test Dim mycell as range 'your code Set myCell = Application.InputBox( prompt:="Select a cell", Type:=8) 'your code end sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks