Search results for query: *

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

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

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

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

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

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

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

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

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