Search results for query: *

I would like to get an image to change by cheking a sertain value in an excel sheet. if the scheet have the value 3 the folowing should happen: Variable = TextBox273 = ws2.Cells(24, 94).Value ('the value 3) Image12.Picture = DetailSelect.Image3.Picture Hovever I want the Image3 to be able to...

I have a picture in an Image in my UserForm. I want to take this picture from the Image and insert it in a certain place on my active worksheet. I have tried to use the following code but it does not work: ws2.Pictures.Insert (Image4.Picture) where ws2 is a my worksheet. Does some one know...

I ma trying to create a user form in which I would like to display a library of pictures form one file. The image should upon selection be transferred to an image box. I am trying to use an image list to define the pictures and then try to show them in a ImageComb. In the ImageList I have...

Yes if that is possible Regg. Do you know if it is?

Thanks but I cant get it to work. First of all it seams only to be working in a module while i am working in UserForms and her I can’t get it to work. On the other hand i can get the code Dim Support As Integer Support = 1 to work in my UserForm but with this i cant use Support...

Dear forum I have a problem that I hope that you can help me with. I am using VBA UserForms in Excel to determine several options that is made by the user. For instance the user can choose between to options button (T-support or pi-support) and depending on that option a cell in my work sheet1...

Thanks for applying but it did not really answer my question. I have already made my VBA code, which is referring to "Sheet1", "Sheet2" and so on. I would like to change my "Sheet1" to "Calculation" and "Sheet2" to "Data" without changing my code. Is this possible?

Hi, I have a question about worksheet names and VBA macros in Excel. Is it possible to change the name of a worksheet in Excel (the name that can be seen in the bottom of the page) whiteout changing the VBA macros connected to them? Thanks in advance/ Markus

Thanks it worked! I really appreciate you’re help

Hi I am having trouble using OptionsButtons in a UserForm. I wand the user to make a choos between three types of options. If he clicks OptionsButton1 row 23 & 24 is to be hidden from the user in worksheet 1( in excel). If OptionsButton2 or OptionsButton3 is clicked the rows should be shown...

Thanks for you’re support problem solved! =)

Thanks I managed to do just that just before you’re reply. As a follow up question I am wondering if it is possible to write the value from another sell in into Cell(8,2). In my case the data in ListBox1 comes from colum 1 in Sheet3 Can I with the code from above get the data from colum 2 (and...

Hi I would like some help wit a UserForm that I am about to create. The UserForm is suppose to present a list for the user in a ListBox and the user is then to select one row. Depending on the selection, data will be transferred from Sheet3 to Sheet1 in my excel document. In my user form I have...

When I am working in MathCAD I am some times using “Area” function from the insert menu. Then when I collapse the Area and later tries to execute, it fails. When the Area then is expanded the data at some places is missing. One time 15 pages of information disappeared something that I can’t have...

Yes I want to calculate the total deflecton of the column it cant be more then H/200. For this I nead the total "I"

I am not shore if this is what I want. In my case I have several beams standing on top of each other bolted together and acting as one. This one beam is then connected in one end to the ground (bolted). For every section I have one Second moment of area, I1 I2 I3 and I4, and the height H1 H2 H3...

Hi I would like to know if someone knows hove to calculate the mean value of Second moment of area (I) for serial connected steel beams. I my case I have one case with 4 beams, and one with 11, with different I and different length placed on top of each other and would like to calculate I for...

Yes I was! Sorry! I cant find out how to do this do you have an example? I would like to read in the text string "200x200x12" for display in mathcad.

Is it possible to read text in to mathlab from excel?

Is it possible to write to a excel file that already holds information with out losing that present info in that file. I want to be able to writ to a pre defined position in a excel file as en example B2