User form

[sunnyp]

Is it possible from user from text box filed will display at two different work sheet in different order.Suppose I have a user form with text filed name when i put any name when i click submit it will display the result in sheet1 in raw 1 column1 and also sheet2 raw 2 column 3 something like that. Please help.

 

[vijaySharma]

Hello Sunny,


Please look at the below link and advise if this is what you need.


https://docs.google.com/open?id=0BxRkrdCm95qbZHJkbDhKd3ZfWlk


~VijaySharma

 

[Lymm]

Sunnyp Did you try viyjays code? I have a version for excel 2003 if you need it.

 

[sunnyp]

That is not what i am looking for what i want is when i put every thing in user form one will copy to 1st sheet where ever i wated and other copy will save as a DATABASE ON OHER SHEET

 

[Luke M]

You can put the info where ever, how ever many times you want. Just add extra lines of code. Example code for the button click:

[pre]

Private Sub CommandButton1_Click()
'Always stores value in range A1
Worksheets("Sheet1").Range("A1") = Me.TextBox1.Value

'Stores value in first blank cell in col A of DATABASE sheet
Worksheets("DATABASE").Range("A65536").End(xlUp).Offset(1, 0) = Me.TextBox1.Value
End Sub

[/pre]

 

[Jack]

@Lymm I wouldn't mind the Excel 2003 version, thanks, John

 

[Lymm]

@John, ok will go find it. You should also be able to do what Luke has sugested. Its no problem to have the data entered wherever you want.

 

[Lymm]

@John Hi This is my latest 2003 version including Lukes code and a few more mods. Let us know what else you need.


http://dl.dropbox.com/u/20269099/sunny2.xls

 

[Jack]

Thanks Lymm for this and to Vijay in the first place!

 

[sunnyp]

Is it possible in user form when you have user form like this

name ___________

Number_101_________

Amount _______


And we have table like this

Number Name amount

98

99

100

101

when you enter 101 in user from tall data will insert in the 101 corespondent row.

Is this possible thru macro.

 

[SirJB7]

Hi, sunnyp!


Assuming your text box controls are named txtName, txtNumber and txtAmount, you can do this:

-----

[pre]

With Worksheets("XXX")
.Cells(txtNumber.Value, YYY).Value = txtName.Value
.Cells(txtNumber.Value, ZZZ).Value = txtAmount.Value
End With

[/pre]
-----


Where XXX is the name of the sheet, YYY the column for Name and ZZZ the column for Amount.


Regards!

 

[sunnyp]

Can you please give me a sample . Thank you.

 

[SirJB7]

Hi, sunnyp!

That's what I did. If you can't implement it, consider uploading your file, specifying detailed requirements and desired output in clean sheet.

Regards!

 

[sunnyp]

I will upload the file

https://docs.google.com/file/d/0B2kKysKalbcNZ2UtQktNekRITmM/edit

 

[SirJB7]

Hi, sunnyp!

You haven't granted the access to the uploaded file.

Regards!

 

[sunnyp]

Now you can excess this file SirJB7.

 

[SirJB7]

Hi, sunnyp!

I downloaded your file, but you have even neither created the userform nor defined the reasonable output cells.

Despite of that, give a look at this file, you'll find there what you asked for:

https://dl.dropbox.com/u/60558749/User%20form%20-%20Temp%20Dailey%20sheet%20%28for%20sunnyp%20at%20chandoo.org%29.xlsm

Regards!