create a button in excel with macros or VBA code in a specific cell targets.

**Giri.hb** · 07-09-2014, 08:42 PM

Hi Team,

I have created a individual tracker spread sheet in each user system and on the spread sheet I have inserted 2 buttons in 1st sheet. when employee wants to take a break he has to click on the log out button and when he came back he needs to click on login button. I have another sheet named "timings" and I have created 2 columns, one is login and another is logout. What I need is when user click on the login button, the system time and date to be auto update under login column and when he clicks on logout button the system time and date to be auto update under logout column.

I have attached the file for your reference. Please advise on creating macro or VBA code. Thanks.

Regards,
Girish

**Olly** · 07-10-2014, 06:25 AM

You can easily do it with one button:

Please Login or Register  to view this content.

**Giri.hb** · 07-10-2014, 07:52 AM

Thank you very much it's worked, but still I need the below thing to be include on the macro code. Please help. Thanks.

1. you have created macro that if i click the button the date and time will auto update in sheet2 but what I need is the time and date to be auto update in specific sheet, eg: i have created a sheet named break, so time and date need to be auto update on that break sheet.

2. once user click on that button the file should auto save along with the date and time updation.

3. will it possible to hide the macro code for the button.

Kindly do the needfull.....

Regards,
Girish

**Olly** · 07-10-2014, 08:03 AM

Okay, so change the code a little:

Please Login or Register  to view this content.

To 'hide' the macro code, simply lock your VBA project in the VBE: Tools > VBAProject Properties > Protection > tick Lock project for viewing (with optional password)

**Giri.hb** · 07-10-2014, 08:45 PM

Hi Olly,

Thank you very much it helped me lot. But I need one more help from you. I need to create one more button which should for login and logout. As per your instruction I have created a button for break and unbreak, for break things date and time will auto update in 2 & 3 column. What I need to when employee login to office he has to click on login button and date and time to be auto update on A column at the start of the day and when he need to go home he has to click on log out and date& time to be update at the end of unbreak time in D column. please find the example below for your reference and also file attached. Kindly do the needful. Thanks.

login Break Unbreak logout

11-07-2014 04:00 11-07-2014 06:00 11-07-2014 07:00
11-07-2014 07:10 11-07-2014 07:15
11-07-2014 09:00 11-07-2014 09:15
11-07-2014 12:00 11-07-2014 12:30 11-07-2014 13:00

Regards,
Girish

**Olly** · 07-11-2014, 04:40 AM

Name your buttons btLogin and btBreak respectively, then use this:

Please Login or Register  to view this content.

**Giri.hb** · 07-11-2014, 07:32 AM

Sorry, I am not getting any inputs by using the above given 2 codes in to 2 buttons. Please advise. Thanks.

**Olly** · 07-11-2014, 07:36 AM

Originally Posted by Giri.hb

Sorry, I am not getting any inputs by using the above given 2 codes in to 2 buttons. Please advise. Thanks.

Attach your workbook, so I can see what you've tried, and advise you what to fix.

Sorry, I can't upload a workbook from this network...

**Giri.hb** · 07-11-2014, 08:05 AM

Please attach the file or send it to my email id [email protected]

**Olly** · 07-11-2014, 08:09 AM

Already explained I can't upload files from this network. I won't be sending any emails to you.

Attach your workbook here so I can see what you've tried, and I can help you fix it. Or not. Up to you.

**Giri.hb** · 07-12-2014, 04:07 AM

Hi Team,

Please find the attached file for your reference that I have inserted the code as your provided for 2 buttons. Please check and advise. Thanks.

Regards,
Girish

**Olly** · 07-12-2014, 04:09 PM

Okay - you've created MSForm buttons, instead of ActiveX buttons, as you were originally using. Easiest way to make my code work is to add two ActiveX buttons, one named btBreak, the other named btLogin.

I'm on home network now, so can upload files - see corrected attachment.

**Giri.hb** · 07-16-2014, 06:50 PM

Hi Olly,

I have tried but still I am not able to create the buttons. I have attached the screen shot that how I have inserting the button. Please check and advise and also let us know if their any way that I can learn VBA macros from basic.
please its my personal request.

Regards,
Girish

**Giri.hb** · 07-18-2014, 10:06 AM

Hi Team,

Can you please some one assist me on the above concern. Thanks.

Regards,
Girish

**Olly** · 07-18-2014, 10:21 AM

You have created ActiveX buttons, but you have changed the CAPTION, not the NAME. Right click the button and click 'Properties', then change the NAME to btBreak / btLogin...

Look at the file I attached on 12th July - look at the properties of the two ActiveX buttons on that sheet.

create a button in excel with macros or VBA code in a specific cell targets.

LinkBack

Thread Tools

Rate This Thread

Display

create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Re: create a button in excel with macros or VBA code in a specific cell targets.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to create a macros that will name a range taking the value of a specific cell?

Create A Button In Document To Disable/Enable A Specific Line of Code

vb code for receive button to substract textBox value from specific cell of sheet

How to create a command button to send specific cells out of an excel sheet..

Create a button to enable macros

Bookmarks

Bookmarks

Posting Permissions