Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vikingatc

    Excel VBA error when running a macro from another form

    I am trying to run a macro located in Workbook B from some VBA in Workbook A within Excel 2007 I've tested this code in some test workbooks and it works great. However, when I try this from the actual workbooks, it does not work. I get an error:Cannot run the macro 'name of macro' The macro may...
  2. vikingatc

    Excel VBA: Set number of items to display in userform listbox

    thanks for your help. The problem persists and I suspect it is likely user error 8). Thanks for your time and for the help.
  3. vikingatc

    Excel VBA: Set number of items to display in userform listbox

    Thanks, but I've exhausted all the normal resources. No one seems to be able to track down this problem. There is no property to set for rows displayed, strange, but true. When I reload the form, the box will show all the results, until the above-described situation results again. very strenge...
  4. vikingatc

    Excel VBA: Set number of items to display in userform listbox

    I've got a listbox that gets its values from a range on an associated worksheet. The range size varies on a search result. The problem is this: if the results returns, say, 5 items the first time it is run, the box will display the 5 items just fine. If the next result is more than 5 items, it...
  5. vikingatc

    Change module in multiple workbooks

    What I am actually trying to do is change the Workbook Before Close event on all of these workbooks... crazy, I know... but there are a ton of them and changing them by hand is gonna be unfun.
  6. vikingatc

    Change module in multiple workbooks

    Rofeu, You're a lifesaver. Thanks. I hate to ask another question, but... how would I go about putting the new code in the Workbook_Close event?
  7. vikingatc

    Change module in multiple workbooks

    I know I read how to do this somewhere, but I can't remember where. Is there some way, I do remember it was through code, to change a VBA module in multiple workbooks. They are all in the same directory, if that helps. (Administrators have decided to add some functionality to spreadsheets after...
  8. vikingatc

    Search multiple workbooks for single range of info

    I'm trying to be able to generate a list of workbooks based on a range they contain called DateofChange. This is a simple date value. What I want to do is, from another workbook using VBA or VB proper in an independent program, to be able to "search" a number of workbooks and sort them based on...

Part and Inventory Search

Back
Top