Macro problem

A

Al

Hi.

On a slide I have a table half of which is arranged as a step table
indicating the distance between 7 towns.
I would like to have two links which on click run a macro to convert the
values in these cells to kil,ometers and another to convert back to miles.

Is this possible? I am not sure how to reference the cells. Would it be
better to do this with an excel spreadsheet ?

Thanks
A
 
J

John Wilson

Probably possible but why not have identical slides one in miles one in km
and hyperlink between them
--
 
A

Al

Was just trying to push my knowledge and see if I could do some fancy
stuff - didn't work though

thanks for your post anyway

A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Macros to convert Data into date format and then plot in graph 7
Powerpoint novice needs some help please 4
Enter value, convert, read result from same cell 1
Excel buttons change macro file name when run on other computers 7
Macro to insert a line when a value changes in a range 1
Web Query question 3
Display formulae as values of each cell reference 7

Top