Control Toolbox - Options

[Ann]

Thanks for your help - I am trying now to do this but if I
want to use Control buttons instead of Forms toolbar, how
do I get them to work - with forms you use the cell link
and then if you click no. 1 you get 1 in the cell clicking
on 2 gives you 2 in the cell and so on - i am using these
so that in another sheet I can use an if statement to
bring in text.

Any ideas??

Ann

 

[Bill Lunney]

Try to keep to a single thread if the question is just a follow up. This
way it's easier for everyone to track. Just hit reply to group or whatever
the button is on your news reader.

Go to design mode. Choose Properties. Set the LinkedCell & ListFillRange
properties to the appropriate ranges on your worksheet.

--

Regards,


Bill Lunney
www.billlunney.com