PC Review


Reply
Thread Tools Rate Thread

browser gives run time 1004 error

 
 
willfeld
Guest
Posts: n/a
 
      2nd May 2008
This was a thread yesterday. i have tried everything i can on google and
elsewhere to fix this. I have a workbook with a user form that enters to a
table sheet. there is a command button that activates all. the code sends
back a run time 1004 Method worksheet_ global error only when i place the
book in the explorer to see if all works before uploading. by itself it
works fine. is this a code issue or browser issue?

Private Sub fconfirm_Click()
Dim C As Control
Dim NewRow As Integer
STOPS ON THIS LINE
NewRow = Worksheets("input").Range("B3").Value + 1

If Len(MyForm.fregion.Value) = 0 Then
MsgBox "The Region field can not be left Blank!", vbOKOnly, "IPA Training -
Input Form"
MyForm.fregion.SetFocus
Exit Sub
End If

Worksheets("Table").Cells(NewRow, 1).Value = MyForm.fregion.Value
Worksheets("Table").Cells(NewRow, 2).Value = MyForm.ftrainer.Value
Worksheets("Table").Cells(NewRow, 3).Value = MyForm.ftrainee.Value
Worksheets("Table").Cells(NewRow, 4).Value = MyForm.fstriation.Value
Worksheets("Table").Cells(NewRow, 5).Value = MyForm.AxDate1.Date
Worksheets("Table").Cells(NewRow, 6).Value = MyForm.fappts.Value
Worksheets("Table").Cells(NewRow, 7).Value = MyForm.fconfirmedleads.Value
Worksheets("Table").Cells(NewRow, 8).Value = MyForm.fcontacts.Value
Worksheets("Table").Cells(NewRow, 9).Value = MyForm.fpresentations.Value
Worksheets("Table").Cells(NewRow, 10).Value = MyForm.ftalkbc.Value
Worksheets("Table").Cells(NewRow, 11).Value = MyForm.ftalkzone.Value
Worksheets("Table").Cells(NewRow, 12).Value = MyForm.ffieldsales.Value
Worksheets("Table").Cells(NewRow, 13).Value = MyForm.fhybrids.Value
Worksheets("Table").Cells(NewRow, 15).Value = MyForm.fapptafter.Value
Worksheets("Table").Cells(NewRow, 16).Value = MyForm.fconfirmedafter.Value
Worksheets("Table").Cells(NewRow, 17).Value = MyForm.fcontactsafter.Value
Worksheets("Table").Cells(NewRow, 18).Value = MyForm.fpresentationsafter.Value
Worksheets("Table").Cells(NewRow, 19).Value = MyForm.ftalkbcafter.Value
Worksheets("Table").Cells(NewRow, 20).Value = MyForm.ftalkzoneafter.Value
Worksheets("Table").Cells(NewRow, 21).Value = MyForm.ffieldsalesafter.Value
Worksheets("Table").Cells(NewRow, 22).Value = MyForm.fhybridsafter.Value

For Each C In MyForm.Controls
If TypeOf C Is MSForms.ComboBox Then
C.ListIndex = -1
ElseIf TypeOf C Is MSForms.TextBox Then
C.Text = ""
End If
Next
MyForm.Hide
End Sub

--
Bucky F
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-time error '1004' Jerry McNabb Microsoft Excel Programming 1 14th Feb 2008 09:25 AM
Run Time Error 1004 =?Utf-8?B?Q2hyaXN0aW5l?= Microsoft Excel Programming 7 16th May 2006 12:33 AM
run-time error 1004 john Microsoft Excel Programming 1 30th Mar 2004 09:53 PM
Excel process remains active after runtime error 1004 in IE Browser window GMGarrettson Microsoft Excel Programming 0 24th Feb 2004 08:35 PM
runtime error 1004 when opening excel file via VBA in a browser Ken Hunter Microsoft Excel Programming 2 31st Jul 2003 03:33 PM


Features
 

Advertising
 

Newsgroups
 


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