View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Webtechie Webtechie is offline
external usenet poster
 
Posts: 84
Default Link a textbox on a sheet to a cell?!

Hello,

I've drawn a textbox on my spreadsheet. I want to link that textbox to the
cell right below it. The reason for this is the text will be bigger in font
that the row below. I already have a prefined print range. So by adding a
textbox, my rows won't be made bigger. The textbox can be formatted to a
barcode font.

Question
======

I don't know how to link a textbox to a cell. I can do it in VBA on a
userform. But on the spreadsheet, can a textbox be linked to a cell?

Thanks,

Tony