Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello all, I was wondering if someone more knowledgeable could give me a tip on something I want to accomplish in Excel 2003. It is as follows: I have a command button sized exactly as cell A1. A click on this button should invoke VBA code that can do the following: a) Enter the current date in cell B1. The code should be able to determine the location of the command button and enter the current date in the next cell over (B1 in this case). b) The code should then be able to read a URL stored two cells over (C1 in this case) and launch said URL in Internet Explorer. Any guidance or a working subroutine that sequentially accomplishes these two tasks would be greatly appreciated. Thanks Arsene |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating excel file, adding code to it from code, VBE window stays | Excel Programming | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |