Thanks. It does go into A2 and so. However, I need the value in the text box to go into A1. Then I need the value/variable cleared then once another value is entered in the text box I want that value in A2 then cleared then A3 etc. Private Sub CommandButton1_Click() 'txtscore.Text = "" For i = 1 To 25 ' hours = Cells(i, "b").Value ' rate = Cells(i, "c").Value count = count + 1 score = txtscore.Text Sheet5.Cells(i, "a").Value = score txtcount = Sheet5.Range("B2") txtmean = Sheet5.Range("B3") txtstand = Sheet5.Range("B4") Next i End Sub

I can only open the door... I can't walk you through it.

The problem I am having is I need to enter values in a text box on a form and transfer them to an Excel sheet. I need to be able to input up to 25 "scores" For example I submit 77 then click submit it runs the following code For i = 1 To 25 'count = count + 1 'score = txtscore.Text 'Sheet5.Cells(i, "a").Value = score 'Next i The problem is it enters score for all values A1:A25 I need the score to be entered in A1 then input another number into txtscore which is my text box. Then after I click the submit button I need that value to be placed in A2 and so on and so forth. Any suggestions? Thanks

I can only open the door... I can't walk you through it.

Open the mmc (just type mmc in the run dialog box) click add the local policy. Also, once you create the user check what security groups the user is in and the permissions and rights of the user. On server 2003 it can be done the same just edit domain policy/GPO instead of local and disable logon local. Depending on how often your gpo updates you may want to run a GPupdate command in the command console. hope this helps.

I am new to Visual basic. I am taking an intro VB class in college and it is pretty basic. This question is not class related and my instructor wasn't sure how to do this. I was wondering how or if it is possible to call a windows application. I would like to call a command prompt so I could code something to work with a command promt running nmap. I haven't had much luck googling so anything to point me in the right direction would be appreciated. Thanks...