创建VB宏的代码 [英] Code to create a VB Macro

问题描述

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

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

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 hlp options, but unable to suceed. 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

推荐答案

假设您正在谈论MS Office宏，我将从这里开始看看 ^ ]

assuming you are talking about MS Office macros I would start by having a look here VSTO Developer Centre[^]

这篇关于创建VB宏的代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！