Search results

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

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?

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

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 I am trying to select a set of fields from a record set and read the data into an array. First off this is to be used with several table recoredsets all having the same naming structure but different qty of fields. Eg Table 1 has fields named "Number_1,Number_2,Number_3 Table 2 has fields...