Programming

How to Create Control Array at VBA Excel
Hii.. I'm new in VBA Excel. How to create control array (like checkbox,textbox,combobox) at userform dinamically and assign exit event (lostfocus at vb 6) and enter event(gotfocus at vb 6) on each that control? In VB 6.0 it easy to do that. Best Regard, :) Heru -- herus -------------------------------------... 30 Aug 2005 22:23

Setting OnAction Property Fails
I have an add-in that works just fine when there is a single instance of it running on a particular machine. However, if two copies get launched at essentially the same time on the same machine, I get the following error: Method 'OnAction' of object '_CommandBarButton' failed. The runtime error number i... 31 Aug 2005 16:23

matrix arithmetic using arrays in vba
Hi there Is it possible to do simple matrix arithmetic without looping through all the individual items in an array? I'd prefer not to use Excel's built-in functions, but this may not be possible. If this is the only way to do it, I heard from someone that there is a way to use Excel's built-in MMULT functi... 26 Aug 2005 19:45

Help in using an Offset in a .Range().Select
I am trying to Select a Range of cells where the last cell is calcualted and will be plugged in at run time. worksheets.Range("A1:C1").Select ' This works of course, selecting A1 to C1 but I wanted the ending cell to be calculated. worksheets.Range("A1", Range("A1").Offset(colTOright)).Select Where colTOrig... 26 Aug 2005 18:12

VBA combo box
hey all, easy question, cant find answer anywhere How do I add items to a combo box in a VBA Form at design mode? There is a LIST property but I can only add 1 item? Thanks in advance! -- krhyme ------------------------------------------------------------------------ krhyme's Profile: http://www.excelforum.co... 18 Aug 2005 14:26

I want to use a oleDragDrop in an Excel VBA Userform
Hello, I am fairly new to VBA and macro programming. I would like to devise a macro that processes a bunch of workbooks. I would like to create a userform such that I can drag and drop workbooks from windows explorer into a listbox to determine which files I would like to process. I found tons of examples on... 5 Aug 2005 09:41

Autofilter
If I want to filter the data so that any row that has a value greater than 0 in column 14 OR does not have a value of 8 in column 18... why does this code not work... It gives me only those rows with values less than zero in column 14 and hides every row that does not equal 8 in column 18! Sheets("CORPS").Sele... 13 Jul 2005 15:36

Sudoko
Does anybody out there have a VB script that will solve Sudoko problems, just to save me the time in writing one! Thanks in advance ... 13 Jul 2005 11:58

How to make Pulldown menus
I need to create an excel spreadsheet that has a pulldown menu at the top that will change the rest of the sheet below it when you select different options. I'm pretty unfamilar with VB (and not all that great with excel either), but quite familar w/HTML and Javascript. Is there any way I can create this pulldown ... 11 Jul 2005 15:46

Search Cells
I am trying to write a VBA code that when executed will search two columns within my worksheet, the first is the date column and the second a column for smokers. When the code is run I would like it to ask the user which date he would like to search for, once selected the program will look for all cells with the speci... 29 Jun 2005 13:37