Search results for query: *

I have created a multipage on a form and I would like to select one of the tabs (page1 /page 2) when loading the form. I have tried a couple of the commands that come up when userform1.mulitpage1.xy however I cant' find the right command to select page1 or page2. Any suggestions are welcome...

I have written a program that generates a report that can be viewed in MS Excel and MS Word. Whereas MS Excel is happy to display a couple of 1000 graphs, MS Word goes mad when pasting in more than 100 graphs. MS Word also becomes pretty slow when pumping in so many data. Is that a limitation...

Well the title says already what I want to do. Ideally I would like to open the default email editor on a computer when a command buten is pressed. Second question: can I insert the email address in the To field of the email? Many thanks for reading.

Hi, I used the two lines of code to display the data in a form. And I want to display the current time as well. How can I do that? Thanks for reading til here. Sheets("my Sheet").Cells(130, 22).value = Date Label6.Caption = Sheets("my Sheet").Cells(130, 22)

Hi there, I think I have a very simple question. I am copy pasting graphs from MS Excel into MS Word (the graphs are transferred via clipboard) Once pasted i want to change the size of the picture. I have tried to record a macro, but the the macro recorder does not allow me to select a...

My application is using the clipboard to transport grpahics from one application to another. Ideally I want to reduce the memory usage by deleting pictures from the clipboard after the job is done, but so far are my apporaches not very succesful. I have tried two things so far, but when looking...

What I want to do is to insert a graph into a form and present to the user. One way of achieving that could be to use the copypicture command (I know haow to do that) and then save it to the hard disc as a jpeg file (but I don't know how to do this) and then insert it into the form property...

I am interested in adding a proper help function to my program application. I have seen in the VBA Project properties a line that allows to add a “help file name”. But I am completely glue less on how to use it. Which format is the file? Could somebody point in the right direction were I could...

So far I have not tried anything. What I want to do is to paste a text into a textbox and than format the text. I not sure but maybe I need a command that can convert the clipboard information into a string and then assign the string to to the textbox.text=string. Any help is appreciated.

Fairly easy problem I guess. Here is what I want to do. I want to read information from 4 text boxes (1 string and 3 numbers). If the user did not enter a number then I want to jump to the errorhandler. What I have done so far is to convert the textbox.text into integer but really want it be...

Is there a more elegant way to assign data to an array? Thanks for your help. source(1) = 5000 source(2) = 6000 source(3) = 7000 source(4) = 8000 source(5) = 12000 source(6) = 13000 Page_Name(1) = "Average" Page_Name(2) = "T-Test" Page_Name(3) = "% Inhibition" Page_Name(4) = "dRFU"...

Being new to programmatically populating a listbox I have written code below. I am using a list box with 3 columns and the code below writes information into an array and then passes the array on to the listbox1.list. So far so good. The thing is that I don't know how to update the current list...

I think that is such a simple question, but I can't find any command in VBA to convert a number such as 1204 into the corresponding string "1204". Any suggestions at this point If have tried to read the number out of a cell and assign it to a string, but that does not compatible with creating...

Here is my first approach with getting information from the internet into my Excel spreadsheet. I have bluntly stolen some code from the Tek-Tip Forum to get started. My aim is to visit a database in the internet...

I am writing a report function and I use the clipbord to transport data (with in Excel or to Word). Ideally I would like to clear the clipbord memory after every paste transaction. Any help appreciated. Code Application.ScreenUpdating = False Do Until weiter = False dummy...

Hyperlinks in charts. Is there an (easy) way to get a hyperlink into a chart. I wonder if I could put it in the title or in the figure legend. Easy question lets see if any answers are rolling in onthat one. Thanks

I am frequently using the =hyperlink() function in workbooks. Now I want to insert a hyperlink with VBA in my workbook. This is the code I tried to use, but the compiler stops in line 4. Any ideas how to insert a hyperlink into a workbook with VBA Many thanks part1 = "http://www.google.com"...

I created a list box and I display a lsit of name (variable in length) and followed by some numeric expressions. Ideally I would like to format the output. The routine below is rough draft. I measure the length of the name using the Len(dummy) function. However I am displaying my data in...

I want to load a form that contains several option button. When I load the form all option button are de-selected. Ideally I would like to show which data had been previously selected and therefore I would like to know how I can make my option button selected when I load the form. Any ideas...

How can I optimize my code? As you can below I have very similar sub's and all I need to pack them into one sub is learn how Sheets("menusheet").Select replace the "menusheet" expression with the sheet name. Any ideas welcome. Thanks again Sub Hide_T_Test() 'delete old sheet...