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: 470
Default Can't Display Userform

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
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
Userform to size to display Jason V[_2_] Excel Programming 2 August 17th 07 02:06 AM
display userform Anthony Excel Discussion (Misc queries) 3 February 27th 07 04:02 PM
Display dates on userform Greg[_19_] Excel Programming 0 February 22nd 05 12:11 AM
How to force userform to display everything? John Mitchell Excel Programming 3 October 13th 04 12:41 PM
How to cause userform to display Jim[_31_] Excel Programming 4 November 28th 03 11:00 PM


All times are GMT +1. The time now is 07:15 AM.

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"