LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Adding and using a calendar


I have a userform that gives allows me to enter a description in
textbox and then it allows me to select expense or income then i
places that info in the a new column that i adjacent to a specifie
column that contains a formula I have created on my spreadsheet t
calculate the entry.

I wounld like to add a calendar to my userform that will also allow m
to add the date to the userform entry. Some dates maybe future som
dates maybe past but I would like to be able to look at my spreadshee
and see that:

081405
mortage

And it is fine if the date appears in description cell or I woul
prefer that it was in the cell above the description.

I have no earthly idea on how to do this!

Please provide detailed instructions on this on.

current code is

Code
-------------------

Private Sub CommandButton1_Click()
If OptionButton1 = True Then
Range("expense").EntireColumn.Insert
Worksheets("CGS").Cells(11, Range("expense").Column - 1).Formula = TextBox1.Value
Else
Range("income").EntireColumn.Insert
Worksheets("CGS").Cells(11, Range("income").Column - 1).Formula = TextBox1.Value
End If
Unload Me
End Sub

-------------------


Than

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46662

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation list after adding a calendar Michael B Excel Discussion (Misc queries) 0 November 13th 08 09:36 AM
Adding Calendar to Worksheet tracktor Excel Worksheet Functions 9 May 18th 08 10:50 AM
Adding a Drop-Down Calendar Paul H H Excel Discussion (Misc queries) 2 December 27th 06 10:36 PM
adding letters in a payroll calendar ryanjh79 Excel Discussion (Misc queries) 6 December 17th 04 06:36 PM
Adding Calendar Control 10.0 to an Excel worksheet? Ron de Bruin Excel Programming 0 August 5th 04 08:17 PM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"