Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
someone misses you badly...
http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
If one is allowed to smile at comments like these then I have a very big
smile thanks for that (LOL) "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
Ooops!
My sincere apologies. I forgot all about this. I'm on it as soon as I hit the "send" button. -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... If one is allowed to smile at comments like these then I have a very big smile thanks for that (LOL) "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
JLatham
Can I ask you a question while youre here? I have a command button that when clicked it goes to another sheet And it works beautifully thanks to other members, I named this button Sunday. now I wish this same buttons name to change automatically when I change a date on a different worksheet. Is this possible? Aussiegirlone "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
I new you would respond to JLathams comment as a little cheakiness goes a
long way. I'm still smiling LOL "T. Valko" wrote: Ooops! My sincere apologies. I forgot all about this. I'm on it as soon as I hit the "send" button. -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... If one is allowed to smile at comments like these then I have a very big smile thanks for that (LOL) "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
Check your inbox!
-- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... I new you would respond to JLathams comment as a little cheakiness goes a long way. I'm still smiling LOL "T. Valko" wrote: Ooops! My sincere apologies. I forgot all about this. I'm on it as soon as I hit the "send" button. -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... If one is allowed to smile at comments like these then I have a very big smile thanks for that (LOL) "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
2-timing on T.Valko now are we? :)
What do you mean by "named" - do you mean you actually named it that or that Sunday is what appears on the button. Also, where did you get the button from: the Forms menu tools or the Controls Toolbox menu? "aussiegirlone" wrote: JLatham Can I ask you a question while youre here? I have a command button that when clicked it goes to another sheet And it works beautifully thanks to other members, I named this button Sunday. now I wish this same buttons name to change automatically when I change a date on a different worksheet. Is this possible? Aussiegirlone "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hey! T. Valko
You can use a worksheet event under the worksheet that contains the cell.
Rightclick on the worksheet tab with the changing cell. Select view code. Paste this into the newly opened code window: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim myCell As Range Set myCell = Me.Range("A1") If Target.Cells.Count 1 Then Exit Sub 'one cell at a time End If If Intersect(Target, myCell) Is Nothing Then Exit Sub End If Worksheets("sheet1").CommandButton1.Caption _ = Format(myCell.Value, "mmmm dd, yyyy") End Sub You'll have to change the cell to look at (I used A1). As well as the other worksheet's name, the commandbutton's name and use the caption you want. aussiegirlone wrote: JLatham Can I ask you a question while youre here? I have a command button that when clicked it goes to another sheet And it works beautifully thanks to other members, I named this button Sunday. now I wish this same buttons name to change automatically when I change a date on a different worksheet. Is this possible? Aussiegirlone "JLatham" wrote: someone misses you badly... http://www.microsoft.com/office/comm...8-5971526f3f2d Seems ausiegirlone needs to feel you near. :) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivotting - T. Valko | Excel Worksheet Functions | |||
MR T VALKO ..PLZ HELP | Excel Discussion (Misc queries) | |||
TO mr t.valko... | Excel Discussion (Misc queries) | |||
mr t.valko ..help | Excel Discussion (Misc queries) | |||
Thanks Pete_UK & T. Valko... | Excel Worksheet Functions |