userform help

[mezzle992]

how do i get my user form to write the text box data on to an active row (highlited row)

[Solus Rankin]

Which column?

[mezzle992]

multiple columns

[Solus Rankin]

Please be as specific as possible with what you're trying to achieve. You want the input from one textbox to be repeated in multiple columns of the active row?

[Fotis1991]

and also,pls take a few minutes to read forum rules and specially in this case, rule#1.

[mezzle992]

my apologies i thought this was one line of code to add above .Offset(rowcount, 0).Value = Me.txtstocktradenumber.Value etc

i have a data sheet in excel which is populated with a user form but it only populates certain fields like barcode product name etc (working) but not fields like postage cost and customer

i then have a search button on the data sheet to open a user form for the user to type in the barcode to find the record they need to update (using autofilter) and then selects the whole row (working)

then once the autofilter has found the row i need a user form to open for the user to enter postage cost and customer info etc on the highlighted/selected row

[mezzle992]

where can i find the forum rules, i need to devolop this program quickly but i want to learn vba properly so i can see myself being a frequent user

[Fotis1991]

where can i find the forum rules, i need to devolop this program quickly but i want to learn vba properly so i can see myself being a frequent user

So you are in the right place! At the top of the page you'll find the button for the forum rules.

[Solus Rankin]

It sounds like you already have quite a bit done. Could you redact any sensitive information from you file and attach it as an example?

This makes it much easier and we can tailor fit a solution.

To attach a workbook, click the 'Go Advanced' button below, then use the paperclip icon in the toolbar to navigate to your file.

[mezzle992]

workbook example.zip

i have come quite away with the code but the book is no where near done, still needs tidying up and i need to put some formula in for the automatic fields like amazon fees and dates. ive put in a couple of random entries so you can see whats going on

[mezzle992]

HaHa oh yeah, i'm gonna stop being dense now.

Fotis1991 (i will get the hang of this)

[KK1234]

Hi everyone,
I am also trying few things in user form and need help.
I have seen your sample book and is way too ahead of what I am doing.
My book is related to two dependent combo boxes. Some what related to your question.
Please help if you can.
Please refer to the following thread.
http://www.excelforum.com/excel-programming-vba-macros/979237-dependent-drop-down-list-in-user-form-combo-box-vba.html#post3535700

Kind regards
KK1234

[alansidman]

KK1234:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.