I am calling a procedure called TRET from an UserForm. TRET is located in sheet6. Here is part of my code:
If A=1 then
sheet6.TRET
else
call SUGAR
end if
The problem is that I can't call TRET from sheet6!! It says that there is a "Type mismatch". What I am doing wrong!!
I have this SUB to look if a file exists. If the file exists it's supposed to do nothing, but if it doesn't exists the file is created. The problem is that if the file already exists the following error occurs: "Path not found." Of course, the file "X" does exists in "c:\".
Sub test()
If...
I have a userform and inside it there is a form with a caption; you know, those letters that cosses the line of the frame. Well, the thing is that I can see the caption in my monitor but, when I print it, it just print everything but the frame's caption. Any help?
How do I delete or clear a rowsource from a combobox? I have a userform called "A" and a combobox called "B". I am trying to use this command, but it doesn't works:
A.B.RowSource = " "
Any suggestion will be very helpful because I have no idea on how to do that.
Att.
MTroche
What is the recomended deflection for a concrete pole? I am working with them and I don't want to make my design too expensive neither too frightening to the people looking the poles too inclined, although it's safe.
Thanks for any help.
I want to copy some cells' values from a worksheet to a page in a multipage, but I can't find how to do this. Note that the worksheet and the multipage is at the same workbook. Following is the code I'm trying to use, but it desn't works.
Private Sub CommandButton6_Click()...
Hallow Everyone:
I want to open a page from a MultiPage thru a VBA Program in Excel, but I have no idea how to do it. Also, I want to make, let's say the page #2, available in some occasions. How can I do it?
Att.
MTroche
Hellow Everyone,
I need help in making a VBA program in Excel to read the Created, Modified and Accessed Date and Time of an Excel file when the same Excel file opens. I know it can be done reading the file properties, but how can I do it?
I'll appreciate any help.
I am trying to automatically hide all toolbars when I open this workbook, but the program always says that CommandBars is empty. What I am doing wrong?! Below you can see my program.
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Private Sub Workbook_Open()
Call HideAllToolbars...
Below is the program tied to a userform in EXCEL. The userform is used to get the desired clearence below a powerline and the place from the lowest pole where the desired clearance will be calculated. The problem is that the span is 25 meters long and I can't calculate the clearance at the...
Below is the program tied to a userform in EXCEL. The userform is used to get the desired clearence below a powerline and the place from the lowest pole where the desired clearance will be calculated. The problem is that the span is 25 meters long and I can't calculate the clearance at the...
Searching in my soil mechanic books I didn't find any information and formula about how to analize the forces that the wind or any other lateral force acting on the pole causes the pole itself to drift. I am trying to analize the lateral forces in the soil due to the forces acting on a...
I have a ComboBox showing the items from an array, but there are some repeated items and I don't want to show the same item twice or more in the ComboBox. How can I do it? How can I make the ComboBox to show each item from the same array just one time and don't show repeated items?
I will...
My program is in VBA. I have a ComboBox showing the items from an array, but there are some repeated items and I don't want to show the same item twice or more in any ComboBox. How can I do it? How can I make the ComboBox to show each item from the same array just one time and don't show...
I want to store some data to a Public Array but the following Error Message appears:
"Complie error
Constants, fixed-length strings, arrays, user-defined types
and Declare statements not allowed as Public memebers of object modules."
I am using a UserForm to get the information at...
Help strongly desired!!
I am working in calculating the sag and tension of transmission cables, and I have this doubt: if I have a ruling span, shall I use the difference in elevation at the beginning and end of the ruling span or shall I use the maximum difference in elevation in the ruling...
... to get the total discharge head (TDH) of a pump? I mean, let say that my pump is higher than the end of the pipeline, and there are soe places lower than the end of the pipeline. Do I have to take both elevations (Z1 and Z2)as the lower and higher point in the pipeline in question? Or...
