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

Recommended Answers

All 3 Replies

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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.