VBA in Excel - using text box string as cell reference

Question

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.

Abe Gold · Accepted Answer · 2013-07-10 03:13:22Z

1

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

answered Jul 10, 2013 at 3:13

Abe Gold

2,38718 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA in Excel - using text box string as cell reference

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related