View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default Dynamic button creation

Why not just one button?
Sub ButtonMacro()
Call mulby(ActiveCell.Value)
End Sub

HTH

Die_Another_Day
mazzarin wrote:
Hi,

I have a column of numbers in an excel sheet. They can be any set of
numbers, but only within the range L15:L21

Is it possible, for every non-empty cell (maybe on error resume next?),
to create a button on top of the cell with the caption set as the
number IN the cell, and for it to call a script mulby(cell.value here)

Thanks for any assistance.