Recent content by buckau

hi thanks for the info but i managed to figer it out the code is 'Select page 3 = "DefultDataPage" MultiPage1.Value = 3 3 is the index of the tab that you wish to go to

I have a user form that has several tab pages on it when the form opens it checks to see if the user has entered there default info if it is empty it needs to go to the default tab so the user can enter there info. How do I do this using vba in excel 2000 I have not been able to find any code...

hi thanks for that but if i set it to High it disables my macro. how do i mack my macro a sighned macro and mack it a trusted macro? steve

I have an excel 2000 application that I have developed which is now working well it has some macros in it the problem is ever every time I open it, it asks me to Enable macros how can I stop it asking me this and just enable the macros?

the only code i have been able to find in is Python and i can not work it out

Hi again I agree with every thing you are saying and that’s my problem I do not know how to do that! A calculate how many rows there should be. Though I do not know if this is very significant, if you can cross check the 2 arrays then it should be possible to keep looping through until no more...

Hi thanks for the reply I know the answer is supposed to be 4 rows because I am using a method that was created by some one else and in this example the answer is 4 rows if the selection is changed to a pool of 9 items (numbers) and the set size is 6 and the guarantee is 5 from 6 (eg if 6 of the...

Hi thanks for the response In the first array Array1 (28,6) I have all the possible combinations of 6 from 8 In the second array (Array2 (56,5) I have all the possible combinations of 5 from 8 The next step is to find the minimum amount of rows in Array1 that will cover all the items in array2...

Hi I am trying to create a function that will compare one list of elements against another list of elements and find the smallest number of enters from the first list that will contain all the elements in the second list. e.g. lets say I have 8 items constructed in to blocks of 6 items this will...

Hi I have an application that has been running well on my old computer, I upgraded to a new computer and now when I run the application I get an “Unspecified Error Runtime error –2147467259” The error happens when the application is transferring to contents of an array to an active x list box...

Hi I have a couple of problems trying to do calculations on a user form with Excel 2000 I am used to using VBA with Access 2000. I have created a data worksheet to store the data that I need to keep called (Database) and another to store lists for combo boxes and list boxes called (lists) and...

thanks for that but i have not got to the stage of adding a form yet! and at this stage i donot know how to add a form to Excel 2000. i have been using access 2000 for about 3 years and am able to creat combos and dropdowns in assecc ok i have never tryed to do it in Excell befor!

Hi I have a work sheet with a lot of data in it relating to time worked each line is a separate day. In my excel book it states that I can turn this work sheet data in to a database it states that I have to highlight the data + 1 line and then go to the data menu and select "set Database" but...

Hi I have a work sheet that I update daily and in the comments column I am consistently entering the same comment I would like to have a popup or dropdown window in this column were I can select an existing comment or a comment from a predefined list and enter it in to the comments cell, I also...

hi thanks for that have tryed a msgbox but it is too small i also need to be able to print the results as formatted and layed out in the Active X list box.