Please Help

[Kmk1605tigre69]

Hi! I’m very new to Visual Basic in Excel and was wondering if anyone would be able to help? I want to be able to enter any number into a text box and click a button that says “Generate.” Once user does this, excel will bring up number of cells in column based on value inputted into text box. Is this possible?

 

[My Aswer Is This]

You said:

and click a button that says “Generate.”

Do you mean a Activex Command Button

And are you saying when you made the Button you entered "Generate" as The Button Text?

And you said:

excel will bring up number of cells in column based on value inputted into text box

What does bring up mean


Give us a exact example of what you want. And what column


We always need specific details.​

_{^{<strike>
</strike>}}​

 

[Kmk1605tigre69]

Command button as in one created in Visual Basic. Text of button is Generate. Let’s say user types 5 in the text box and clicks Generate command button..action would bring up cells A2 through A6.

 

[My Aswer Is This]

Still do not understand this:

action would bring up cells A2 through A6.

What does bring up mean?
​

 

[My Aswer Is This]

And what happens if user enters 10 into Textbox

 

[Kmk1605tigre69]

How about call up cells A2 through A6?

 

[Kmk1605tigre69]

If user enters 10, then cells A2 through A 11 are called up.

 

[Kmk1605tigre69]

Once Generate is clicked on

 

[My Aswer Is This]

Your not telling me what

call up means

Call up ???

bring up ???????

​

​

 

[My Aswer Is This]

Try this:
Assuming your Textbox is named TextBox1

Private Sub CommandButton1_Click()
'Modified  5/9/2019  10:39:28 PM  EDT
Dim r As Range
Dim ans As String
Dim n As Long
n = ActiveSheet.TextBox1.Value
For Each r In Cells(2, 1).Resize(n)
    ans = ans & r.Value & vbNewLine
Next
MsgBox ans
End Sub