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
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.