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

    Changing colour of AutoShape

    thanks for the reply, got it sorted anyway, it seemed that VBA doesn’t like you saying .Select("AutoShape" & 1) you need to say .Select("AutoShape " & 1). weird one I know. thanks for the quick response anyway S.G
  2. greengo

    Changing colour of AutoShape

    My problem is that depending on a value in a cell on my sheet the colour of and AutoShape will be changed. When I record the macro it seems to record all the correct functions. But when I try to run the code nothing happens to the shapes. Anyone got any idea’s
  3. greengo

    Getting info from a web page using VBA

    Hi all, I’m not sure this can be done but I am want to know if it is possible to get information from a web page that is opened from a hyperlink on an excel spreadsheet. the reason for this is that I can get direct access to the database that stores the information(to much red tape) which is...

Part and Inventory Search

Back
Top