(Solved) – VBA – How to have user input a cell with a userform

(solved)-–-vba-–-how-to-have-user-input-a-cell-with-a-userform

I am building a userform with VBA. I want to be able to generate a list of random numbers, and have the user input what cell they start in. I have a textbox called txtStartingand a range called userstarting.

Private Sub txtStarting_Change()
Dim userstarting As Range
userstarting = txtStarting.Value
End Sub

The form doesn’t let me type in the full value of the range. Like if I want to start with cell B1, as soon as I type in B, it gives me an error.

Leave a Reply

Your email address will not be published. Required fields are marked *