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...
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...
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
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...
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...
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...
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
