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

    unprotect sheet + make visible

    I have a worksheet that is hidden. Whenever the checkmark is clicked, which would result in F12="TRUE", then I want it to open this other sheet called "Polymerase". However, the sheet is protected w/ a password, and I do not want it to prompt the user w/ the password. I have...
  2. peach255

    add-in problem w/ setting workbooks

    I have a macro that manipulates the cells from 2 workbooks. It prompts for 2nd file to be open, do some calculations, and then copy and paste some cells from 2nd opened workbook to the 1st workbook. This procedure worked fine when I run it from the .xls file. However, when I have it as a add-in...
  3. peach255

    autofill not working

    I have an autofill VBA code to fill the cells from a formula. When I run the procedure, it did not autofill. However, when I step through the code, it did autofill each cells. I am not sure why it does not work when I run the procedure, but works when I step through the code one by one. Here is...
  4. peach255

    interacting w/ 2 workbooks?

    I have a workbook open, and then I prompt the user to pick another file to open on a new workbook. From there, I have some procedure to do some manipulation on the new workbook. Then I would like to go back to the 1st workbook and do some more manipulation of the 1st workbook , and then copy...
  5. peach255

    scan for repeating values and then delete

    I would like to loop through Column B, and if I find the same repeating value, then I would like to delete the rows and keep only one. I would always have 4 replicates, but would only like to keep one. For ex., Loop through Column B, and if found "A2" multiple times, then delete 3 out...
  6. peach255

    search for a text in a Column and then delete

    I am not too familiar w/ looping and searching for text in Excel cells. I would like to look at each cells in Column E, and everytime it sees the word "Standard", delete the whole row. How can I do this? Thank you!
  7. peach255

    write to txt file WITHOUT quotes?

    I have the following code which I write teh values from a range in Excel to a txt file. However, it's writes the values back w/ quotes (") around the values. If I add the code : If IsNumeric(vData) then vData = Val(vData), this would get rid of my leading zeros in my values. For ex...
  8. peach255

    open a file?

    How can I have Excel open a file? For ex, a Word document called "test.doc"? I have the following code to open the Word application successfully, but I basically just want to open the file. Thank you! On Error Resume Next Program = "WINWORD.exe" TaskId =...
  9. peach255

    export range to a txt or csv file??

    How can I export only Column A & B of this worksheet to a txt or .csv file? I have the following code so far, and it is not working: Set ExpRange = Columns("A:B") ExpRange.Select With CSVFile .ExportRange = ActiveCell.RangeSelection .Export...
  10. peach255

    loop through range + call query

    I have a macro that runs a query from an external db. In the WHERE clause, it will be taking the parameter values from 2 cells in the sheet. This is what I have ... Sub Plate() plateid = Worksheets("sheet1").Range("A2").Value wellref =...
  11. peach255

    interconnected pull down menu?

    I have 2 pull down menus called "dept" and "discipline". I want the discipline pull down menu values to be dependent on the chosen values of the "dept". For ex., if dept=PRCL, then values for discipline= ACH, GEN, if dept=DISC, the discipline=CHM, and all else...
  12. peach255

    simple math calculations in text field

    I have 2 text fields (ar_date1 + ar_date2) which the user has to enter some #s in. Then I would like a 3rd text field (ar_date_total) to be autocalculated and populated based on the users' input. I do not want the user to press any button for this to occur, but automatically populate when the...
  13. peach255

    email validation in checking for ".com" string

    I have the following code that is giving me an error when I tried to add the piece on making sure the email has ".com" at the end. Otherwise, when I take out that piece of the code on checking for the string ".com", it works. My code is as follow: checkEmail =...
  14. peach255

    pull down menu validation

    Hi. I have a pull down menu in my form. Is it possible if I can have the default selection in the menu be set to a blank? And how do I validate the form to make sure the user did choose a selection from the pull down menu? I have the following code to validate a text box, but how about validate...

Part and Inventory Search

Back
Top