Dear all
I have sheet with table
contain more than 100 column
each row represents one patient
I need to make user form
I can enter data in it
and it contain button
when I press it it will send details in user form into next empty row in my table
i need vba equation to link between
I can use excel very easy
I have zero knowledge in VBA programming
Thanks allhttps://www.excelforum.com/attachmen...1&d=1490652244
Which data fields need to be on the userform? Columns A through....??????
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
You could make use of a a built in dataform. This is used for Database updates...Can add new, delete old or edit existing.
Check out this link:https://excelribbon.tips.net/T006207...ata_Forms.html
Or to call the form from a commandbutton in userform, this code should work.
Please Login or Register to view this content.
Last edited by sintek; 03-28-2017 at 02:00 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
all columns starting D column...
Originally Posted by sintek
You could make use of a a built in dataform. This is used for Database updates...Can add new, delete old or edit existing.
Check out this link:https://excelribbon.tips.net/T006207...ata_Forms.html
Or to call the form from a commandbutton in userform, this code should work.
Please Login or Register to view this content.
thanks
let me try this
but i do not know where to add this..
Dear
i did this form for this table
but i can not fix the link between both
if you can help me to complete it
thanks
https://www.excelforum.com/attachmen...1&d=1490768116
Last edited by x_ampl1; 03-29-2017 at 02:15 AM.
Here is a sample file. This dataform only works if the fields are 32 or less. If you require more, a userform will have to be built.
Here is a example of a Userform to update or edit a database
Dear Sintek
thanks so much.
It is working
But i need to apply it on my user form
that I had loaded it
in last file.
consider that there is drop down list in some fields .
can you check it
or guide me how to link both with same way
i will continue other columns.
https://www.excelforum.com/attachment.php?attachmentid=509526&stc=1&d=1490768116
thanks
Perhaps, it is time for you to employ the services of a VBA coder...This task can be done, however, as much as we do love to help out, we cannot unfortunately take on entire projects. The above example worksheet and suggestions are more than adequate to get you started.
maybe this
@ unit285
If I may make a suggestion...
Perhaps you could look at using list rows add - as the data is in a Table
Please Login or Register to view this content.
Last edited by sintek; 03-29-2017 at 02:44 PM.
@ sintek
Excellent point. I was hoping the op would be able to maybe use it as a starting point to learn vba etc.. using list rows add is a better solution then what i put into the userform
Dear Sintek
You did alot
thanks for your kind care.
I think it is easy think
but when i sow your codes
it is big
really big.
thanks so much again
I will do my best
Realley you did much to me@ unit285
If I may make a suggestion...
Perhaps you could look at using list rows add - as the data is in a Table
Please Login or Register to view this content.
I can not express my thanks for you
you completeed it to me...
Thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks