Visual and Excel

Computing.Net > Forums > Programming > Visual and Excel

Original Message

Name: Night
Date: October 3, 2007 at 18:41:09 Pacific
Subject: Visual and Excel
OS: WinXP Pro
CPU/Ram: AMD64 X2 4200/1024
Model/Manufacturer: Abit AN8

Comment:

I'm trying to make it so when I click on a date on the calendar set in Excel that it gives me the date in mm/dd/yyyy in box D1. That's fine, here's the code:
Private Sub Calendar1_Click()
Range("=form!d1").Select
ActiveCell.FormulaR1C1 = Calendar1.Value
End Sub

Here's the problem, I have a second sheet called Results. It's where I would like the mm/dd/yyyy I selected on the first Form page to go. Any help would be great. Thanks.

Abit AN8 Socket 939
AMD64 X2 4200 @2.5Ghz
Corsair 1Gig Dual-Channel 2x512
MSI Radeon x800 PCI-E
Seagate 160Gig SATA
WesternDigital 80Gig SATA
WesternDigital 160Gig SATA
Antec TC

Report Offensive Message For Removal

Response Number 1

Name: Razor2.3
Date: October 3, 2007 at 20:50:17 Pacific

Reply: (edit)

Sheets("Results").Range("D1").FormulaR1C1 = Calendar1.Value

Report Offensive Follow Up For Removal

Response Number 2

Name: Night
Date: October 4, 2007 at 17:49:22 Pacific

Reply: (edit)

You got it! Thanks Razor2.3.
Abit AN8 Socket 939
AMD64 X2 4200 @2.5Ghz
Corsair 1Gig Dual-Channel 2x512
MSI Radeon x800 PCI-E
Seagate 160Gig SATA
WesternDigital 80Gig SATA
WesternDigital 160Gig SATA
Antec TC

Report Offensive Follow Up For Removal


converting nesned text and excel fi VB.NET; ADO and Excel 2000 VB Script and Excel - Sheet Names vb and excel VB and EXCEL HELP	C# and Excel Excel VBA Problem saving file Creating a DataBase using Excel VBA Excel Cell Border in VB6 Chinese fonts

Kix Script Error

.exe ebooks

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Visual and Excel

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes Today.
Discuss in The Lounge

FTP Server. Under XP

Lock ups

Connecting wireless network printer

Windows Update Issue

MS Access Treeview Drag problems

All Posts Awaiting Replies