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 Rhinorhino 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: *

  • Users: pi
  • Content: Threads
  • Order by date
  1. pi

    Average line in charts for Excel 97

    Hi I have values in a worksheet which are shown on a chart in another worksheet. The values are sales figures for each month of the year to date. If 5 months have been recorded then an average is obtained and I have inserted an average line onto the chart-manually. Is it possible that the...
  2. pi

    Matching fields from a drop-down box to another list

    Is it possible to match the choice from a drop-down box to insert a corresponding field(matching field) in a text box when I choose from a dropdown box. In excel this is possible but I do not know how to achiev this in word. If someone can point me in the direction I would be extremely grateful...
  3. pi

    Using forms and userforms- how do you do this

    I am creating a form and mostly using the buttons from the forms toolbar. However I want to use the spin and option buttons in various groups. I know how to create userforms and to show the form. However when I mix the both I cannot access the userform when I protect the form, as this is the...
  4. pi

    Saving a template file as a document file

    Hi I have created a form with text boxes and pull down lists and successfully saved the file as a template file (*.dot). However when I fill the form and want to save as a document file (*.doc) the dialog box for choice of file types to save is greyed out. How can I get this to work? Thanx...
  5. pi

    Linking cell value to image file

    Is it possible to link the resultant value of a cell to a particular jpeg file. What I mean is say a value of 1 to 5 will place a photographic image on a worksheet and other ranges( say 6 to 10) will reurn other images. If this is possible how can I do this. Please consider my lack of any VBA...
  6. pi

    Comment on macro button

    Hi Is it possible to get commentary to be revealed when the cursor is passed over a macro button from a form. Please note that I do not mean the comment got from the Insert/Comment menu. I am using Excel 2000. Thanx for your help. Regards Dasi
  7. pi

    Formatting for ListBox

    Hi I am new to VBA. I am using a listbox to call up info from another worksheet. All this works well, BUT I need to display bold fonts and background colour to certain fields. Is this possible? Thank you for any help or pointing me in the right direction. Regards Dasi

Part and Inventory Search

Back
Top