user2566550
user2566550

Reputation: 1

VBA in Excel - using text box string as cell reference

How would one use the contents of a text box to reference a specific cell? I would like to be able to enter a cell range (A1:A10, for instance) into two text boxes and then apply a function to that specific range of cells.

Upvotes: 0

Views: 1628

Answers (1)

Abe Gold
Abe Gold

Reputation: 2357

Range(textBox1.Text & ":" & textBox2.Text)

Upvotes: 1

Related Questions