Search results

The userform code is in the first post.

How do I copy down the formula in cells A350 and E350 to A351 and E351 after I input data from a UserForm in to Col B to D ?

Here is the sheet.

Hi Narayan My code puts a new row of data into a table which has around 350 rows of data the problem is to add the formula on each end in col a and e

I am filling Col a and e with formula's with the following code, How do i change it to only fill up only one cell Private Sub CommandButton1_Click() Dim GradingCol As Integer Dim LastRow As Long If Len(TextBox2.Value) = 0 Then MsgBox "The Name field can not be left empty!", vbOKOnly, "Derry...

The formula is filled into L2:L10932 correctly.

devendra.dvm seems from his posts to not even try to solve his own problems or to modify code to get what he wants, I myself will try and when I am stuck ask for help ( See my post about ListBox ).

I use table for input of new "Players" and its used for Lookup it has to be sorted.

Whats wrong with my comment ?

Hi Hui Thanks for the information, I have now been able to remove 30,000 odd rows. Derek

When i find last row in "D" to add an item, its at the end of the defined range, Ie row 30,000

In my Name Manager I have a defined name which can not be deleted or edited, Any ideas as to how to remove it ?

Hi Chihiro Thanks for the reply, Code works well.

Hi Chihiro Cmdbutton3 should move name to Textbox1 then Textbox2 Etc, Single selection of name and a check to ensure all 10 Textbox's are full.

Here is a reply to this from another forum. Sub compare() Sheets(3).Activate 'Go to sheet 3 Cells.Clear 'and clear all previous results Range("a1").Select'set cursor at the top Sheets(1).Activate 'go to sheet 1 Range("a1").Select'begin at the top Dim search_for AsString'temp variable to...

Hi all I am looking for help on populating my textbox's from the listbox.

Nice and simple guide, Only 9,700,000 google results to look at :)

I am looking to learn about UserForms, IE:- to place names to a range of cells on file open, how to show "A2:A400" and select to textbox and wright to sheet, Any web sites etc for me to look at. Derek McGill

Design it your self and you will get help with code to get it to work.

Hui That's what I meant to say. Narayan That code is not for counting no. of cells with the same color in them.

Hui The only catch is, if you make any changes in the data range, formula will not automatically recalculate the result.

Hui Is there any way to get total no. of cells in a range that have a red/green fill color?

Any tips as to the best way to update cells with color function result after vba changes cell color ?

Copies:=Range("B1").Value is the way to go, Thanks.

As a little tweek how can you change "Copies:=1" to a value other than 1 ?