Data Input using VBA excel forms

i have currently made a form using excel see below
forms.jpg
i would like to create a code that would use the textbox1 and textbox2 as search criteria
and then for it to insert the data in textbox3,4 and 5 into required cells

for example
textbox 2 to search for the worksheet for requested Vehicle Reg then
textbox 1 to search for the cell with the exact date already inserted then
for the data in textbox3 to be written in B4
for the data in textbox4 to be written in C4
and for the data in textbox5 to be written in E4

in any one sheet per vehicle i have 365 days
and i have a total of about 51 vehicles

any help would be greatly appriciated

the code i have already for the ok button is as below,

Please Login or Register  to view this content.

again any help would be greatly appriciated

Hi, Darrel1986,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


====

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Ciao,
Holger

Hi, Darrel1986,

thanks for editing the code, what about a workbook? Will the vehicles be on a sheet each on itīs own, will they be on a daily/weekly/monthly/quarterly sheet? How is the date on this sheet created: values or formula dragged? Is this as Row or Column? The UF doesnīt pass that information.

Ciao,
Holger

Hi, Darrel1986,

still donīt know exactly how your worksheets look like so this is my one and only guess at it:

Please Login or Register  to view this content.

Ciao,
Holger

There are 51 of these worksheets in the workbook
All go upto December
The yellow column has a simple formula in it and do not need anything to be written in these columns