Search results for query: *

Thanks Loomah, I tried moving my code to ThisWorkbook. It runs there, but halts with Runtime Error 91 "Object variable or With Block variable not set. Here is the code : Option Explicit Public wksMe As Workbook Public tlbWalkdownToolBar As CommandBar Public butReOrderSheet As...

Greetings All, I want to code a custom Commandbar for a simple Excel workbook application. A few buttons to run macros. This is not a persistent object, it should be created when the workbook opens and disappear when it closes. I've got the Commandbar and the buttons and the macros set...

Thanks Skip, that worked like gangbusters! Now I just have to count the number of charts and do some math to increment the .Top position of the new chart on the sheet. Piece of cake!

Here is a sample of the manually entered data Date PRO# Unit# Name Origin Destination 6/1/04 0606306 4771 Graham CO IN 6/1/04 0606312 4763 Beights CO GA 6/1/04 0606315 4592 Carey CO MO 6/1/04 0606323 4590 Gaudet WA CO 6/1/04 0606327 4640 Brown NE OK Here are the...

er, uh, how do I do that? Is there some way to attach a worksheet, or do you want an inline text representation of the data? Short description: each line in the worksheet is input manually to track truck loads dispatched during a month. There are 1000 lines for data input, and starting at...

Here's the code. I'm self-taught, so please be gentle. This is Excel 97 by the way. Public Sub cmdChart() Dim strActiveSheet As String 'name of the Active Sheet Dim arDateChange() As String 'an array to hold all possible dates in a month Dim datDateA As Date...

I am working on an Excel application that programmatically creates a chart. I have the basics of this realized, but the chart size, the titles, axes and data labels seem to choose their own size values, even when I have specified them in VBA. I got the code to format the titles, axes and data...

PS Yes this is exactly what I needed. I have the code for the command buttons in a module, and a button named "cmdNewSheet" on the existing worksheet that copies the worksheet it is on and then renames the new sheet using an InputBox. I noticed what you said, that my command buttons get...

Thanks, Skip, for the timely tip. I can make Access jump through flaming hoops, but no, I don't really know what I am doing in Excel. If I at least had the VBA help files on this office machine, or could install them myself, I'd be asking far fewer simplistic questions.

Thanks for all your help, folks. I have another question: How do I programmatically rename a commandbutton in Excel 97? I don't have VBA help installed on this office computer or I'd look it up myself. I've just about driven myself bonkers trying to guess the correct incantation for...

I am working at an office that uses MS Office 97. I'm trying to build an Excel application to track daily productivity in (loads scheduled) a trucking dispatch office. The helpful IT people neglected to install the VBA help files. Can anyone post the code to copy the active worksheet...