Help about macros

[psyclone]

I'm trying to make an excel file where the main sheet would contain a button i could click and would popup an entry field where i will input my data. after supplyin the necessary information, i would just click submit or done and the data will be automatically populated in another sheet... i'm lost on the command which i can use. is there a way to do this without using macro? please help. thank you

 

[agihcam]

Hi-
Welcome to the board.
I dont think this can be handled without a macro as you have explain.
If you already have a codes for this, you can post here so that we can review.

 

[psyclone]

thanks for the warm welcome kabayan. actually, all i have is raw data. say for example i have an item which has a code, something like an inventory type excel file. item 1 have a tracking code of 1234. what you need to enter is the code of the item, the description and the price and some other information. then after putting all the necessary information, click done and it will automatically save it to a designated sheet.

hope this helps. thank you

 

[agihcam]

ok. Hit Alt + F11 to open VBE.
from the left side, you can see VBA Project..., right click to it > insert Userform. from the toolbox, drag 3 textboxes and one button into userform1. double click the button and paste this code;

Private Sub CommandButton1_Click()
Sheets(1).Range("a" & Rows.Count).End(xlUp).Offset(1) = Me.TextBox1.Text
Sheets(1).Range("a" & Rows.Count).End(xlUp).Offset(, 1) = Me.TextBox2.Text
Sheets(1).Range("a" & Rows.Count).End(xlUp).Offset(, 2) = Me.TextBox3.Text
End Sub

then hit F5 to activate the userform.
hope you can start with this. the data you have entered into these textboxes will goes to Sheet1 columnA,B,C

 

[psyclone]

hi. This is really cool

i was able to create my file. just have one question though. is there a way to put a button on my main sheet to call up this form? sorry, this is all new to me. i'm not really familiar with VB codes and commands. but i'm digesting your codes. i tried to add 2 more text boxes. if you want, i can show you my file. thanks a lot.

 

[agihcam]

from your worksheet, click on view > toolbars > control toolbar ( if not yet tick ). then locate where a commandbutton is. left to it, then left click somewhere on the worksheet, hold and drag a little to the right and down then release. excel will create a commandbutton.
now double the commandbutton and put this code;

Private Sub CommandButton2_Click() 'change based on actual commandbutton named.
Userform1.show
End Sub

 

[psyclone]

i think i'm doing something wrong! i can't find the previous macro i created and the button that i created is not calling up the form. i'm not really familiar with the command.

 

[psyclone]

still need help on this one. the button is not doing anything. it's not calling the form.

 

[agihcam]

Read your PM and good to hear that you were able to do it.