Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is the code used to try and display userform, but I keep getting an
error. Error = File Not Found. Runtime Error 361 - Can't unload or load this object. Any ideas? Thanks, Les Private Sub CommandButton42_Click() frmCompare.Show End Sub Below is the other code associated with userform. I am just starting to write the code, so it is not complete, but what I have already written "should" work. Private Sub CommandButton1_Click() Dim cmpcntcat, ccntcat, currmnth, cmpmnth As Integer 'NOTE: l (lowercase "L") & c = last & current months Dim curr_rng, comp_rng, Cell As Range Dim lcat(50), ccat(50) As String Dim os, k, ck As Integer os = 62 '#Rows to offset to each month currmnth = Month(Date) For k = 1 To 12 If OptionButton & k.Value = True Then cmpmnth = k k = 12 End If End Sub Private Sub UserForm_Initialize() Dim mnth(12) As String mnth(1) = "January" mnth(2) = "February" mnth(3) = "March" mnth(4) = "April" mnth(5) = "May" mnth(6) = "June" mnth(7) = "July" mnth(8) = "August" mnth(9) = "September" mnth(10) = "October" mnth(11) = "November" mnth(12) = "December" Label1.Caption = "Current Month is" & mnth(Month(Date)) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform to size to display | Excel Programming | |||
display userform | Excel Discussion (Misc queries) | |||
Display dates on userform | Excel Programming | |||
How to force userform to display everything? | Excel Programming | |||
How to cause userform to display | Excel Programming |