The ford smallblock is quite prone to cracking between cylinders. This is where mine broke when frozen, even though the cooling system had been drained (obviously not well enough).
Good luck,
Grnegg
Bobo60,
you are thinking of the Ford Model T... This car actually has the torque tube driveline as well as a planetary transmission. This amazing transmission only needed addition of a control scheme and some actuators...which would have made it essentially equivalent to modern automatic...
ab123456,
Thanks a bunch. The problem was indeed caused by defining the value was set in a separate subroutine.
Grnegg
palusa,
The abovew fix also rectified the inability to pull up the worksheet names.
Thanks
Subject code is as follows: where my sheets are G-01,G-02, etc.
Private Sub ComboBox_click()
thesheet = ComboBox.Value
End Sub
Private Sub SaveButton_Click()
Worksheets(thesheet).Activate
Cell populating code (this works)
End Sub
Private Sub...
Both suggestions (onlyadrafter and palusa) are slight variations of what I've already tried. After further experimenting, I believe that my problem is with the "activate" command. This command doesn't appear to like my sheet name variable ("MY_SHEET" in onlyadrafter's solution and "TheSheet"...
My workbook contains multiple worksheets of identical format(only the names vary). I have created a form for data input. This form includes a combo box which is supposed to identify which worksheet the remaining information (inputted to the form).
Here in lies the problem. I haven't been able...
