Search results for query: *

I tried recording a macro and rewriting it to change the location of what I want to link to and have the following, although nothing seems to happen: Range("ActiveCell").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "At 60!I1"...

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

I don't suppose there's a way to just use VBA to do Data > Validation, and change the source of my list by simply changing the reference name is there? I'm currently trying to put together this MS Query but don't seem to be getting much luck. Err.

If I use MS Query, will I have to worry about keeping my tables/columns within my workbook in a permanent location? Because this file would be shared in a network drive and passed on to other computers through email.

I have my resultset tables set up already. Is there a way I could just change the list source directly through a macro without using a query or would the query be required?

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

Forgot to add, but I also need to be able to make references to cells in the invisible sheets. Also is it possible that if I have a macro that copies a sheet that I could use it to copy an invisible sheet, but the copy as a visible sheet?

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

When I tried out that code in the Form's Current event Procedure, it worked at some times but all the time. Would there be a problem in this if my combo boxes were in a main form and the data displayed and entered were shown below in a subform?

Nope, I put the GROUP BY statement in my data properties for my combo box. Everything is working as I need it, but when I delete or add new information, it won't immediately show up in the combo box (unless I reopen the form in some cases). Is there any way to keep the combo boxes always...

Aggregate?

Thanks, actually I stumbled across this tutorial on SQL for beginners and found that I needed to do a GROUP BY Function. http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/SQL_for_Beginners.asp

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

Whoops, I didn't notice that you can set the property throught the toolbar above... Clumsy me.

Ya, Skip mentioned that I should move my question to this forum. Although as for the worksheet_change event, how would I implement it?

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

Wouldn't I need a function if I wanted to monitor A1 continuously? Or is there a way so that as a sub A1 is always being monitored?

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

Well I'm trying to keep tack of hours for several tasks being done (for a total of 12). What I have is InfoRecords1, InfoRecords2... InfoRecords12. I'm making a report that summarizes all 12 tasks performed and I collect all my data from a query called qrRecordStack. The only thing is not all...