Thread: Selection Grid
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default Selection Grid

On Sat, 24 Feb 2007 07:03:08 -0800, JLGWhiz
wrote:

The short answer is no. However, it can be moved to another cell. There
must be an active cell on the active sheet, so there is going to be a cell
with a black "grid" somewhere on the sheet. You can pick a cell to move it
to and simply use:

ChoiceCell.Active

With ChoiceCell being replaced with the actual cell reference.


That sounds like it'll do nicely. Can you give me a example of usage,
please?

I tried "A1".Active and variations thereof without getting the right
syntax. And no help from F1.

Thanks - Kirk