CODEWITHSUNDEEP
vbaexceltextbox
jason w
jason w

Reputation: 11

Take Textbox input and move to a specific cell.

I'm writing a macro to pull various data from an Excel sheet and put it in a more usable order. A problem I've run into is that one section of the data I want is contained in a textbox. I'd like to pull the data out of the textbox and have it all pasted into a cell, A100.

The textbox is always called ActivityA.

Upvotes: 0

Views: 2637

Answers (1)

chris neilsen
chris neilsen

Reputation: 53137

try this

Cells(100, 1) = ActiveSheet.Shapes("NameOfYourTextBox").DrawingObject.Text

Upvotes: 2

Related Questions