Textbox over a bit map in EXCEL SHEET

[dinilkarun]

hi,

I want to put a textbox over a bitmap in MS Excel sheet and populate the textbox with a value from VB code. Please guide me in acheiving the same.

Regards,
Dinil

[cguan_77]

hi don't know if this is what you mean.. insert your desired bitmap... then put the textbox on it.. then put the code on vba like this..

Sub fox()
TextBox1.Text = "ok"
End Sub

[dinilkarun]

I want to do the following in excel sheet fully using VB code.

1. Placin 1 single bitmap from (1,1) to (1,8) cell
2. Placing a text box over it.
3.filling the textbox with text.

THe above solution is not clear.

Regards,
Dinil

[cguan_77]

pls. checked attached file..check the macro...thanks..