Search results for query: *

I can't seem to figure out what is wrong with this line of code, I get a multitude of errors depending on what changes I make. The one I am getting with this specific syntax is "Select method of range class global failed" Worksheets("" & hydraulics.actoggle.Value).Range("B65536").Select When...

I have a series of forms to carry out various tasks in an excel workbook. I am trying to figure out the best way to start the first form. I am thinking a button of some sort from Excel, but am not sure how to do it. I don't want it to start automatically when the workbook is opened, I want it...

I have a text box on a user form. I want another user form to be able to reference the value from this text box. e.g. Activesheet.name = "Text " &textbox.value I tried making the Sub public in that module, but it doesn't recognize it in the module for the other form. Any ideas? Thanks, Chris

I have the following code which I found to sum the data fromt he current range of cells. I tried asking at tht site, but the thread seems to be long since forgotten. When I run it I get as error saying "Method 'Range' of object '_Gloabal' failes"...I am very new to VBA, so I am really...

I am trying to use VBA to sum a certain selection of cells. But I need it to input the formula with cell reference into Excel, not just the value it calculated. The only way I cn come up with is to name the selected range and use ="=SUM(SelectedRange)" The problem is that I need to be able to...

I am trying to create a userform which interacts with a database. I have textboxes whose control source are linked to cells on the spreadsheet. I select one piece of equipment from the database and copy its info to the cells which are the controlsources for my textboxes. This uploads the...

So I have a database which catalogs all possible components of a piping line (pipe, elbows, valves, etc.). For each possible piece of equipment, there is an associated pressure drop based on the fluid flowrate, and length of pipe/ number of valves. So what I am trying to do is filter the...

I have macro which uses a combobox to filter a database based on criteria in the first column. I want to then pull the info from the remaining columns into text boxes on the user form, so that the user can alter any of the entries (such as number of parts) before I paste that entry into another...

I have two comboboxes that I want to use as filter criteria for database. The first combobox would display criteria from column A. Then once a selection is made, the choices avaliable in combobox2 would change depending on what was selected in the first box. I can't seem to get this to work...