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 TouchToneTommy 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: LizF
  • Content: Threads
  • Order by date
  1. LizF

    Option Button properties - can I copy them?

    Hello Folks, I wonder if any of you clever people can help me? I am setting up a Word questionnaire, and I need to use a very large number of Option Buttons. There are a number of properties I want to change (~5, the same for each button) to get them looking good, and so I was wondering if it...
  2. LizF

    Strange inability to delete selection change event sub...

    Hello folks, We are having a weird problem here... In one of the sheets of my workbook I ended up with a... [code] Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub [\code] ...by mistake. I don't need or want it so I tried to delete it. Problem is, whenever I try...
  3. LizF

    Conditional formats in Excel - using IF to get same format for 2 diff

    Hi folks, Hopefully this will be an easy one for you all, as I'm sure I've seen something about this when browsing the forum. However I can't for the life of me find the same thread, so here goes... I'm using conditional formats in Excel to alter a cell's background colour (Red, Amber or...
  4. LizF

    Problem with dates taken from Excel

    Hello again... My code picks up a date from a cell in one Excel file and compares it with one from a cell in a second Excel file. My problem is that while it works fine for one file, it returns the wrong date from the other. It's nothing obvious like 31/12/1899, and I think I'm picking up the...
  5. LizF

    Picking up data in Word, putting into Excel?!?

    Hello people, Does anyone know if it's possible to pick up data from Word (I think the bits I need are in a Word table...) and paste the value into a cell in Excel? If you could tell me how that would save me much worry, as if this is not possible I have to convince some senior people that...
  6. LizF

    Copying data into a cell in an Excel file using named range and row

    Hello folks, Thanks to the help received in response to my previous question, things are progressing well with my code. However, I'm stumped again!! My client Excel file is a large spreadsheet. Each Row contains a number i.e. z12345 along with a load of other information. My code can now...
  7. LizF

    Using VBA to search filenames for namematch then take data from file

    Please excuse my newbie naivite, but I'm struggling here! I need to write some VBA code in a client Excel file to search a folder ("server") for filenames matching my criteria (e.g filename contains z31245). Then I need to extract data from certain cells in that file and copy the...

Part and Inventory Search

Back
Top