VBA Array receive value from text box

Jack_JT

New Member
Joined
Aug 26, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Dear all professional vba,

i'm very newbie for vba, i'm in the mist about array vba as picture below.
i want to receive data from button one by one to keep in array
anyone can guide me for this solution?

i) when i click button on the right side the value on the button will show in the table of the left side
ii) the grid show from left to right and then go to new row to start again.
1598494876665.png

Your kind feedback is much appreciated. TQVM!
Jack_JT(VBA Newbie)
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
⁉ Sorry, but I am confused by your question. Your thread title says "VBA Array" but your picture shows a range of cells and your thread title says "text box" and I only see "buttons". Please clarify exactly what you are trying to do for us.
 
Upvote 0
⁉ Sorry, but I am confused by your question. Your thread title says "VBA Array" but your picture shows a range of cells and your thread title says "text box" and I only see "buttons". Please clarify exactly what you are trying to do for us.
sorry for my mistake
I want to show our put like a picture
 
Upvote 0
What do you currently have set up? Are the buttons on the worksheet already? If so, what kind of buttons are they... Forms or ActiveX? What are the button names? What would probably be useful is if you posted a copy of your workbook to DropBox and posted the shared link here so we can download it and use what you already have instead of trying to create it from your description.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top