User form codes

[lady_alina]

Hi,

Location Furniture Item Vendor

I created a user form in excel its working fine but the problem now is in each location there can be same type of different items of furniture say for example - Look at the example below:

Location Furniture Count of furniture Item Count of items
1 Chairs 10 D1 10
1 Chairs 2 D2 2
1 Table 1 T1 1

My question is can I enter in furniture box using a comma and it gets separated by itself in different rows and Location gets copied as many times as i entered furniture separated by comma.

Or can anyone give me a better solutions please. I can shwo you my code if required. Need this urgently, please help.

 

[lady_alina]

excellent, it worked thanks a lot no nosparks......... Can you help me with one more thing... I have another sheet where I have check box for each line of item and If i check mark the boxes I want the data to appear in next sheet with all columns... Could you help me with the code please.

 

[NoSparks]

Glad to have helped.

You should post your new question separately as this thread is unlikely to have many more views and the subject title is not related.

 

[lady_alina]

Ok will do that, One more thing related to the same topic -
What if I want the following also to break up same like classtextbox
Classcount
Classcost
Item
ItemCount

What will be the code for that.

 

[NoSparks]

Well, everything would have to have the same number of entries, arr already determines how many, so you could try this in that same procedure

    Cells(emptyRow, 4).Value = Split(CLASSCOUNTTextBox.Value, ",")(x)
    Cells(emptyRow, 5).Value = Split(COSTTextBox.Value, ",")(x)
    Cells(emptyRow, 6).Value = Split(ITEMTextBox.Value, ",")(x)
    Cells(emptyRow, 7).Value = Split(ITEMCOUNTTextBox.Value, ",")(x)

 

[lady_alina]

Perfect....Thanks