(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 *