View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Programming Ideas

Brian,

For your second question
Use Format Sheet Background and find a picture or whatever.
This will be duplicated across your worksheet.
Or use cell shading.

For the first
Dim msg as String
msg = MsgBox("This is my value" & Chr(10) & Range("A1").Value, _
vbOKOnly)

Assign the macro to the button.
--
sb
"brian" wrote in message
...
I have a 2 item wishlist of items that could be done with
programming. I use a construction estimate workbook that
can have several estimates for one project in the book and
some of the estimates can be pretty long (9 or 10 printed
pages).

1. Can I create a button that displays the value of a
cell (With a short description). It would be kind of like
the watch box but a lot easier to read and docked onto the
toolbar in the size of a drop-down button.

2. Can a background be added to a sheet so that I can
differentiate sheets when looking at it? All estimate
sheets tend to look the same when you have 6 of them and
it is 15 minutes before the bid. I'd like a sheet name or
something to show up kind of like a watermark in the
background. It would have to move with the scrolling or
be repeated as you go down the sheet.