PDA

View Full Version : return cursor for manual cell selection in excel vb macro



rodney_malod
02-27-2006, 02:04 AM
Any clues on a method to return the cursor during the execution of a vb macro for manual selection of a cell the location of which can then be fed back into the macro

Bob Phillips
02-27-2006, 02:43 AM
Any clues on a method to return the cursor during the execution of a vb macro for manual selection of a cell the location of which can then be fed back into the macro


ACtivecell.Address

perhaps

mdmackillop
02-27-2006, 11:15 AM
You could show a userform with a RefEdit control

Norie
02-27-2006, 01:15 PM
You could try Application.Inputbox.