将日历链接到特定的单元格 [英] Linking a Calendar to a Specific Cell
问题描述
我将日历图标插入了电子表格并分配了日历宏.当我单击该图标时,日历会弹出并允许我选择一个日期,但是该日期会显示在光标碰巧所在的任何单元格中.有谁知道我如何将日历上选择的日期链接到特定的单元格?谢谢.
I inserted a calendar icon onto a spreadsheet and assigned a calendar macro to it. When I click on the icon, the calendar pops up and allows me to select a date, but the date shows up in whatever cell the cursor happens to be in. Does anyone know how I can link the date selected on the calendar to a specific cell? Thanks.
推荐答案
我在电子表格中插入了日历图标并已分配 日历宏.当我单击该图标时,日历会弹出并允许我选择一个日期,但是该日期会显示在光标碰巧所在的任何单元格中.有谁知道我如何将日历上选择的日期链接到特定的单元格?谢谢.
I inserted a calendar icon onto a spreadsheet and assigned a calendar macro to it. When I click on the icon, the calendar pops up and allows me to select a date, but the date shows up in whatever cell the cursor happens to be in. Does anyone know how I can link the date selected on the calendar to a specific cell? Thanks.
- Moved by Ruhul Laskar Monday, February 01, 2010 9:55 PM issue related to macro (From:Creating, Formatting, Filtering and Sorting Data)
好吧,另一个人移到了错误的论坛. Ruhul,这是 VB.NET 论坛,而不是Office论坛.如果您有一个明显的Office问题需要移至Office论坛,则下面的链接可能会有用处:
对于VBA,Office(VSTO),宏和VBScript问题
:)
Well, another one moved to the wrong forum. Ruhul, this is the VB.NET forum not the Office forum. Here's a link that might be of some use next time you have an obvious Office question that needs to be moved to the Office forum:
For VBA, Office (VSTO), Macros and VBScript Questions
:)
这篇关于将日历链接到特定的单元格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!