Search results for query: *

Is there a way in VBA to create a hyperlink to a refrence of cells?

I have an excel workbook that will perform calculations for wire sizes. Based on a certain "amp load", I need to be able to display multiple combinations of wires used. I have created a seperate worksheet listing different wire combinations for various "amp loads". Is there a way to have a...

Is there a way in Excel that I could hide and show certain worksheets, but keep them all in the same tabbed order?

I have single table that will hold the following information for ProgrammingCodes: author, version, description, hyper-link to file. I have a combo box for each one set so I can filter through each entry based on any one category. The only thing is I linked my combo boxes to my only table...

I'm not sure why, but I keep getting an Else without If error. Any ideas? On Error Resume Next Exists = Sheets("MCC" & x) If Err.Number = 0 Then 'sheet exists so do nothing Do If y = x Then y = y + 1 End If While (Sheets(y) = Sheets(x))...

I have set a marco to rename a sheet based on the number entered in a cell, my code is as follows: Function RenameSheet(place As Integer) ' What needs to go in place of "Me" ' In order to select the current sheet? Sheets("Me").Select Sheets("Me").Name = "MCC " & place End Function I jsut...

I have set a marco to rename a sheet based on the number entered in a cell, my code is as follows: Function RenameSheet(place As Integer) ' What needs to go in place of "Me" ' In order to select the current sheet? Sheets("Me").Select Sheets("Me").Name = "MCC " & place End Function I jsut...

Is there a way to put an 'if' statement in a control source similar to how I could use the Nz() or IsError() function in my control source? What I'm trying to do is just have a textbox have a control source of '= 0' when there are no current records in the corresponding field in my query. I...

I have a form that will update a query for StaffInformation, this query has data for: name, worker ID, wage, and phone number. For my tables, I have set the worker's ID number for the primary key and as the only field in one table with a 1 to many relationship to a second table that holds all...

I have a report that will display the cost for 12 different tasks from 1 to 12. If no cost exists for a task, then it's not displayed at all in the report. For each task, a total cost for each Task is seperately listed in a textbox. Is there a way to sum all these totals from the one textbox...

If I have have a form that stores records on various program codes (most would be saved in text pad files), is there a way to link the actual files to my database and open them through Access?

I have a form of 4 comboboxes corresponding to categories of: Author, Type, Version, and Description. All of these categories are categories for a database of Programming Codes I have within a subform. Is there way I can set the Master/Child links so that I can search through my listing based...

I'm trying to make a database that would store Program Codes. What I'm trying to do is that in the end I will have a form that can search code on any category. These categories would be: Type, Description, Version, Area, Author. So far I only have 1 table that stores all this data but am...

I'm trying to have a function where 1 cell is based on the values of three cells. Where the final value (LoadValue) is equal to LoadLevel. However I need to LoadValue to return a value such that LoadLevel * DC >= Left. I keep getting a #VALUE! error. My code below is shown below. Public...

I have multiple sheets where a single sum of multiple values for each sheet is displayed at the top. I'm trying to create a 'Summary Sheet' that will add all those values together and dislpay it in one cell. The only thing is that at times I'll be adding and removing extra sheets. Is there a...

I'm trying to do an if statement as follows: If (Cells(r, c) > 20) & (Cells(r, c) < 25) then I'm trying to check for a cell between two values but am not sure on how to do this boolean statement with the '&' sign. Any ideas?

In my Excel Spreadsheet, I have 1 cell that monitors the value of two other cells. The cell monitoring is supposed to change values based on what the user will input for the two cells. I created a macro, but is there a way, to have the macro always running so the user will never have to do it...

I have a 2-column table listing 'Size' and 'Point'. On a seperate sheet, I have three cells listed across as 'Estimate', 'Rating', and 'Breaking'. In this, the values in 'Breaking' are equal to 'Rating' * 1.25 and I want to increase 'Rating based on increasing values of 'Point' until the value...

I have a report called TaskSummary, where each page dislpays results for 1 of 12 tasks regarding a summary of total costs and hours per each worker in different subtasks. Is there a way to create a seperate report that would summarize the total costs and hours per each worker for each task as...

I have a main that the user can choose a number from a combo box and the form will then only show records for a task relating to the selected number. The records displayed are shown is the category 'SUBTASK' in the subform 'sfrmAllTasks' and 'frmEIStaff'. Clicking on a command button will...