help! macro textbox
 

Hi everyone--

I am trying to create a textbox using macro in excel, but I'm have some
problems.

Does anyone know the code that I need to enter to make a textbox?

Can I make it create the textbox in any range that I select?

Thank you so much! = )

help! macro textbox
 

Is this what you're looking for?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Target.Address
End Sub

--
Dan


On Jun 16, 10:22*am, aprice1989
wrote:
Hi everyone--

I am trying to create a textbox using macro in excel, but I'm have some
problems. *

Does anyone know the code that I need to enter to make a textbox?

Can I make it create the textbox in any range that I select?

Thank you so much! = )