Dynamic Textbox Location

**webshockerz** · 03-01-2013, 01:25 AM

I want that the location of my textbox be placed after the last cell in a range that contains a value. Is this possible using vba code?

A1 = 22

A2 = sample

A3 = sample 22

A4 = textbox will be placed here.

**jraj1106** · 03-01-2013, 01:33 AM

Hi.

Is this what you want? Just try this macro code:

inserttxtbox.xlsm

**webshockerz** · 03-01-2013, 01:40 AM

Close enough. Considering that I can enter values in my range and it will automatically be after the last cell that contains a value.

**jraj1106** · 03-01-2013, 01:41 AM

Can you post an example?

**webshockerz** · 03-01-2013, 01:42 AM

By the way adding a textbox is no longer needed. The textbox is already there, part of the design. My only concern is its location. Thanks more power

**webshockerz** · 03-01-2013, 01:54 AM

Consider that I have 15 cells in my range as an example.

A1 = "sample"
A2 = "sample"
A3 = "sample"
A4 = "sample"
A5 = "sample"
A6 = "sample"
A7 = "sample"
A8 = "sample"
A9
A10
A11
A12
A13
A14
A15

Out of my 15 cells 8 of them have values. The textbox already exist regardless of its location in the worksheet. I want the result that the textbox will be after the last cell that contains a value for this case it will be on cell A9, since the last cell that contains a value is Cell A8.