• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to pass For Loop through three text boxes.

Hello Friends,

I am new to VBA .I am working on a project in which i have the following objects.

1.Sheet1
2.A user from having six text boxes with three buttons.

The First three text boxes are for date,Supervisor Name and Job / File Ref
The next three boxes are for Fuel Expences,Toll Tax and TA/DA

What i want?

I want that when i click the save button,then date enter into Cell(1,1),Supervisor name entered in Cell(1,2) and Job Ref enter in Cell (1,4).

And the data of the remaining 3 text box enter as i have fill in sheet 1.

I required your help for my learning purpose as well as for my project to complete.

I attached my file and putt the data manually in sheet 1 for which i required your help .
 

Attachments

  • outstaion.xlsm
    15.3 KB · Views: 2
see how the attached works?
 

Attachments

  • outstaion.xlsm
    20.2 KB · Views: 2
I have now added Buttons to allow you to goto the Previous or Next records and edit them

upload_2018-1-20_11-18-11.png

[Update] Fixed date format
 

Attachments

  • outstaion.xlsm
    23.5 KB · Views: 2
Last edited:
Back
Top