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

    Join Table Issues

    So here's a fun question I would really appreciate some help on. The actually problem uses more complex data, but if anyone can help me solve the problem below, either with a VBA example or through querries, I would really appreciate it. Okay, so: Two tables: Table 1 AgencyID Begin R End...
  2. Benoni2

    Excel: Spell Check while Sheet is locked

    I have form in excel. I have locked most of the cells except for the four on the page that I want the user to type into. I then want them to be able to spell check those four cells using a button. Problem: Though this works fine when the sheet is not protected, as soon as I protect the sheet...
  3. Benoni2

    Excel: Cells as variables in VBA + Range Question

    I am trying to sort a page in excel. The trick is I want it to sort a range of cells that might change as new rows are added by the user. I am working off of the macro excel wrote when I started sorting. What I want to do is set the first cell of the range into a variable as well as the last...
  4. Benoni2

    Excel: New row at the end with a macro?

    I want a button that inserts a new row at the bottom when they have finished up with the available rows. So far though the insert button when recording a macro adds it above the selected record. Also, when repeated, it does the action off of the record that you origonally selected which pretty...
  5. Benoni2

    Excel: Very frustrating, top record of selection won't sort

    Weird, I have a list of names in a column that I want to sort alphabetically. When I try to sort, it leaves the top value selected and sorts all those below it. I am working with vba taking the values elsewhere once sorted, but it should affect this part of it. Any idea why the top value remains...
  6. Benoni2

    using vba to reference cells on different sheets

    I am trying to move the values from one excel sheet to another Sheet1 is named "Quarter Overview" and sheet2 is named "Activity Report". The nicest solution would be to just use an excel function or referencing to move the values from sheet to another. But what I have found so far is that the...
  7. Benoni2

    [b] combo box in Excel - Not the simple one [/b]

    I am trying to program a combo box using the one on the control toolbox. I don't want to use excel's simple built in combo box because it leaves the dropdown arrow outside the cell. I can't figure out the code to use to program it in vba however. I get bits and pieces of what I need to do, but I...
  8. Benoni2

    making a set of excel rows scroll on the page

    I have an excel form where I would like several rows on the top of the page and several rows on the bottom of the page to remain stationary on the page while I scroll through the middle sells. This is very similar to freeze panes or split feature in excel, except I want to be able to do it...
  9. Benoni2

    Event in main form to erase values in subform

    I have a form with a subform. I am trying to get a few values in the subform to be cleared when using the after update event on an object in main form. I can't seem to figure out how to access the fields I need to erase in the subform from the object in the main form. Any ideas on how to do this...

Part and Inventory Search

Back
Top