i have created a payslip of employees but it is not changing values if click a button

**baig123** · 05-23-2014, 05:09 AM

i have created a payslip of employees in Excel using vba(macros) and i have created button called [payslip] it should create for evry single employee in a single sheet but it is not changing values if click a button

i ahve assigned salaries for every employee in a worksheet when i click the button it should display the output of the every employee

if i change the salary(40000 to 45000) in main sheet if i click the button it is not changing salary(4000) in the output sheet

Please Login or Register  to view this content.

**nathansav** · 05-23-2014, 05:41 AM

Can you attach data/example to see?

**baig123** · 05-23-2014, 06:02 AM

This is the file please let me know it is not working properly

**nathansav** · 05-23-2014, 06:19 AM

I dont think you are taking the salary in 40000 is from the template not the data.

Change the 40000 in your template to SHOW_ERROR and then run and they will show SHOW_ERROR for all salaries

**baig123** · 05-23-2014, 06:36 AM

if i change in the main employee sheet

1st employee as got 45000 something if i change that 15000 there itself then if i click the create payslip button it should change inthe output sheet but it is not

**nathansav** · 05-23-2014, 06:48 AM

Yes, because you havent coded it to. Do what i said, then you'll see.

**baig123** · 05-23-2014, 06:59 AM

if i change the value 40000 to SHOW_ERROR it is showing like this #value

**nathansav** · 05-23-2014, 07:12 AM

Yes, but in the payslips generated, will show.

So in the template i put in PLEASE_SHOW

TEMPLATE

PF No. DSNHP0939937000/95
Name Of Employee: ESIC No.Nil
Designation:
Earnings Payable Deductions Amount
Total Days: Basic PLEASE SHOW P.F
Days Worked: D.A E.S.I
Absent: H.R.A 20000 Advance Sal. Deduction
C.L: C.C.A Loan Instalment

PAYSLIPS

08/05/2012 PF No. DSNHP0939937000/95
Name Of Employee: AJAY KUMAR ESIC No.Nil
Designation:
Earnings Payable Deductions Amount
Total Days: 30 Basic PLEASE SHOW P.F 780
Days Worked: 30 D.A E.S.I 166
Absent: 0 H.R.A 20000 Advance Sal. Deduction
C.L: 0 C.C.A Loan Instalment
E.L: 0 Conveyance Allowance: 800 Other Deduction

Your code doesnt populate the basic salary.

**baig123** · 05-23-2014, 07:42 AM

how would i write a code to generate a salary payslips for employees using this (edit salary in sheet1) if i click it should generate a payslip(OutPut)

please help me out to write a code

i have created a payslip of employees but it is not changing values if click a button

LinkBack

Thread Tools

Rate This Thread

Display

i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Re: i have created a payslip of employees but it is not changing values if click a button

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] click on a color button and after button click it will color entire row of cell you click

VBA Macro to input values into web form and then click button and get results back

[SOLVED] Changing font attributes on click of button

how can i tell if people/employees are using a workbook i created?

Click events on buttons created at runtime only work on the last button created

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions