Insert Table For input data into USERFORM

[Rafaelpresa123]

Hello guys

I need to insert data in a userform but i need to put it as a table with double entrace

ACTION/SECTOR:

SECTOR 1 SECTOR 2 SECTOR 3 ... SECTOR 11
ACTION 1 INPUT DATES HERE ON EACH "GRID"
ACTION 2
ACTION 3
ACTION 4
....
ACTION 20

Is there a way to do that?

[Rafaelpresa123]

Hello guys,

Any hint on how to do this ?

[torachan]

see big yellow banner - how to upload your workbook.
lot easier to understand what you want with a typical sheet that you have filled out.
torachan.

[Rafaelpresa123]

see big yellow banner - how to upload your workbook.
lot easier to understand what you want with a typical sheet that you have filled out.
torachan.

I attached example.

I need the option button to be clicked and the ones clicked insert TOday's data on specific cell
Same for Textbox that will write the appointment date

[torachan]

can not program a picture - upload the workbook

[Rafaelpresa123]

Sorry for that, i've now put everything on test excel book
File is updated

[Rafaelpresa123]

Since i need that to be from 1-30, Is there a way to put 5 at a time and have a scroll sideways button ?

[torachan]

what do you want the scroll sideways button to scroll ???

[Rafaelpresa123]

Since there need to be 30 columns, there is not space on the userform, I need someway to fit them all

Using a scroll to scroll them in

Probably i am not making me understand.. but try to put there 30 colums and you will have no space to all of them

[torachan]

i am confused, your grid on the userform is 2 - off 5 x 5
how do you propose to layout 30 columns ?

[Rafaelpresa123]

That's why i am putting my faith in you

Some kind of scroll or other idea can be used...

I need to put information on a huge database, and doing a double entrance table we resume some information

[torachan]

Let's start from basics, layout the database sheet with ALL the columns labeled.
And 10 or 20 rows of dummy information that would be typical of what you want to store.

[Rafaelpresa123]

First of all, thanks for your time and patience to help me

I've attached a file with part of my data base

I need to put from a userform, the values on YELLOW AND RED column according.

I have a listbox that i select the ROW, then in that row i need to put all the information


Check the Userform i've made for the "checkbox" issue, i need now a scroll and to solve the "...." problem that are the other 20 rows
Besides that how to update values to the database

Thanks for your help

[Rafaelpresa123]

Mr. torachan
I upload the workbook "TESTE",

1st need:
When checkbox is ticked put today's date on that column

2nd
When textbox of "table" filled, put textbox value

I have the Columns all todays for 1st case and 2nd case, this way probably with offset and loop through checkbox/textbox is possible?

[torachan]

Sorry, hopefully someone else will pick this up.
It has to make sense to me for me to help.
My reaction, there has to be a better way, if i could understand the purpose.
torachan.

[Rafaelpresa123]

I need to put 30 data for each letter (A/B/C/D/E/F/G/H/I/J).

According to data insert put in the database on the correct column

That is my need, let me know if i can explain better what i need

The scrollbar i mean to use with this probably:
Click on the UserForm
in the UserForm Properties window -
Set ScrollBars to 2
ScrollTop to 0
and ScrollHeight to a number that is larger than the height of the UserForm
So if the height of the userform is 100, change the ScrollHeight to 200



Now how can i import checkbox to the database with faster code instead of one by one code

[Rafaelpresa123]

Mr. Torachan

I've updated my Userform that i have with the scroll and all the checkbox's

Can you help me out on the code to update the values to the data base?

[torachan]

To demo what I think you are trying to do I have grouped your columns(110 columns) in groups of (10 + Master)
This is then possible to loop through with code on the save button.
To enable you to select the correct row first make a selection in the combobox.
Hopefully the method is of some assistance for you to continue with you coding.
torachan.

[Rafaelpresa123]

That is exactly what i need.

Although i have on
Categ Qtd
A 20
B 10
C 10
D 20
E 30
F 10
G 20
H 20
I 10
J 10

My last file i have the userform done, but how do i export, since i don't have 10 columns for all of them ?
For my tests on your file B2 is not getting updated data.

I think i need to have a loop on "Checkbox" & i and define variable for the first column and then offset i

[Rafaelpresa123]

Hi torachan, is there a way to export data from 30 columns, then only 20.

Define Start and End For each column
and start cell then offset on the excel sheet

[torachan]

ensure your textbox number can be related in sequence to your cell column.
then a series of loops for each column of varying lengths, as you need to check each check box i cannot see how you can offset a whole column.
see the attached its simply setting the relationship of the textbox number to the cell column.

[Rafaelpresa123]

Thank you very much