Recent content by sdiverdan

That's it. Knew it was simple. I was using the year and 2015 is an integer... Thanks for the quick reply! Dan

I could not find this question in the forums. Thought it would be a simple solution. I'm using Excel 2013 and have VBA code to select a worksheet. My worksheets are years 2013,2014, 2015. Depending on the command button on my userform, I update cells in a particular spreadsheet. In my code I...

SkipVought, the GetSaveAsFilename saves the whole workbook doens't it. I don't want everyone to save a massive database/VBA spreadsheet just the small worksheet of their search with their own path and filename. The GetSaveAsFilename does give them the option of specifying a path and a new...

I searched this forum looking for how to bring up the Excel SaveAs windows screen. I have a spreadsheet database that produces a worksheet resulting from the users search critera. I can bring up the print preview screen if they want to print the worksheet results. What I haven't been able to...

Got it! Finally figured it out. Simple really when you use the Evaluate. Here's the final code: in my main form: Private Sub VType_Click() 'view type Sheets("Tables").Range("FName").Value = "Types" Sheets("Tables").Range("FRange").Value = Evaluate("TypeName").Address 'TypeName is a...

macropod was right! I forgot the with statement as DaveInIowa pointed out. When something's not working you try all kinds of things and I must have deleted my with/end with statement with a cut and paste. Stupid!! .List = Sheets("Tables").Range("FRange").Value works However...

Yes I did. I receive a compile error stating that it's an invalid or unqualified reference. That's basically the problem: how to reference defined names. Dan

I'm having a problem accessing the defined names of my worksheet. I have names defined in my workbook and can access them like this: Private Sub Introduction_Click() MsgBox Evaluate("Itext"), vbInformation + vbOKOnly, Evaluate("Ititle") End Sub This is a simple message box showing the...

Thanks, I thought so but had to try. Dan

I have an excel workbook that's basically a small database. A vba userform accesses the data and has buttons that perform simple searches. I would like to access the userform without having to open excel. So I need to create a program or convert the vba into an executable. How can I do this...

thanks xlhelp! I had to also put in an extra ')' before the "Vacant" and viola it works beautifully! [2thumbsup] Dan

I posted this in the Office 2003 forum and did not get a response so I'm trying this forum. I'm really stumped. I have two sheets (call it Sheet1 & sheet2). Sheet1 is: Name Team Position Bob 2 1 Dan 5 3 George 1 2 Mac 1 1 Ted 2 2 this sheet is sorted by name...

oh... one more thing if the team/position is not there I want to return "Vacant" versus a player's name. Dan

I'm stuck again and this time it's turing my hair gray! I have two sheets (call it Sheet1 & sheet2). Sheet1 is: Name Team Position Bob 2 1 Dan 5 3 George 1 2 Mac 1 1 Ted 2 2 this sheet is sorted by name. Sheet2 is a report that looks like: Team 1 PlayerA team 1...

Thanks Ken, here's a star, that's exactly what I was looking for! thanks...[thumbsup] Dan