请帮助下面给出确切的宏程序! [英] Please help in giving the exact macro program for the below !!!

查看:91
本文介绍了请帮助下面给出确切的宏程序!的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好,我想创建一个具有以下条件的模板.请帮助我执行以下操作的代码.我从商业背景上就不喜欢VB.我尽最大努力使用帮助选项,但无法成功.请帮助我.
1)应该有两个命令按钮,1)启动时间和2)结束时间.
2)当我们单击命令按钮时,它会提示输入人名,当我们输入该人名时,它应该进入具有该人名的列
3)在具有今天日期的行中,应捕获系统中的当前时间.对结束时间"按钮也应执行相同的操作.
4)单元格充满当前时间后,电子表格应自动保存.
5)单元不应超越.它应该受密码保护.只有知道密码的人才能覆盖该单元.
请对此提供帮助,因为需要监视项目中处理器的中断时间.

1)开始时间2)结束时间
处理器名称六月-06- 2011六月-07-2011
开始时间结束时间开始时间结束时间
阿贾伊
桑杰伊
公羊
开发
拉吉

解决方案
我们当然可以是能够帮助你解决问题,但痛心地说没有做的代码为您服务.我们在这里可以提供的帮助是为了帮助您解决在创建程序时遇到的问题.我的建议是为您提供一本书,并开始学习VBA编程.


Hi, I want to create a template with below conditions. Please help me on a code that would perform the below actions. I dunno VB as am from a commerce background. I tried my best with the help options, but unable to succeed. Kindly help me.
1) There should be two command button, 1) Start time & 2) End time.
2) When we click on the command button, it should prompt for a person name, and when we enter that persons name, it should take to the column with that persons name
3) In the row that has today''s date should capture the current time in the system. the same action should be done for the End time button too.
4) As soon as the cell is filled with current time, spreadsheet should be automatically saved.
5) the cell should not be able to over-ride. It should be password protected. Only the person who knows the password should be able to over-ride the cell.
Kindly help me on this as this needs to be monitored for the break time of the processors in the project.

1)Start Time 2) End Time
Processor name June - 06- 2011 June - 07 - 2011
Start Time End Time Start Time End Time
Ajay
Sanjay
Ram
Dev
Raj

解决方案

We can certainly are capable of helping you with your problem but sad to say were not doing the code for you. The help we can provide here is to help you solve issues that you will meet while creating the program. My advise is for you get a book and start learning VBA programming.


这篇关于请帮助下面给出确切的宏程序!的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆