VBA Command Button Macro

**Thrawler** · 01-16-2012, 11:18 PM

Ok, this is an interesting one I think.

I have a Worksheet, and a Macro which will load a User Form.

the User Form as 2 Combo Boxes, One lists peoples name (Found on WorkSheet 2) and another will list a type of Gear (Found on Worksheet 3)

I have a Button which needs to take the selected person from the first combo box, find there location on Worksheet 1 (Found somewhere in the A Column), and edit the corresponding cell in the D Column. I actually need it to take its current Value and Add a predetermines variable called TotCost

So what I need help with, is the code to do the Search for, and edit Corresponding Cell in D

**rylo** · 01-16-2012, 11:42 PM

Hi

To save us some time, can you attach an example file with your workbook, the form, and relevant buttons that reflects your real situation.

rylo

**Thrawler** · 01-16-2012, 11:48 PM

Ok, so I haven't added the code to pull up the Userform, and ignore my horrible coding I'll make it look pretty once I get it all done..

So basically, what I want it to do, is when the person "Add Loot Total to Spent Points" I want it to take the value of totcost and add it to the selected person Sent Points section. So if they purchased a gear for 1000 it would take the current 100 and add 1000.

**rylo** · 01-17-2012, 12:26 AM

Hi

OK, here's one way.

Please Login or Register  to view this content.

this is the code for the command button Add Loot to Spent Points

HTH

rylo

**Thrawler** · 01-17-2012, 12:29 AM

What did you dim findpoints and findchar as?

Dunno if this will do what I need it to do. I know my explanation was horrible and I apologize for that.

I need the Button to find the name located in the first combo box on the Points Sheet, and take the corresponding value of that persons Spent Points, and Add the variable Totcost to it.

That Make sense?

So lets say, Altair is in the First Box, and the 2nd box says Head Piece, the value will show up under the button, that value should be added to Altair's Point Spent

**rylo** · 01-17-2012, 01:11 AM

Hi

I got lazy and didn't do the dims. Make them both ranges.

Did you actually run the code and see if it did anything?

rylo

**Thrawler** · 01-17-2012, 01:15 AM

Just got it to work now, I had to fix the Run-time error.

It does exactly what I needed it to do.

Now to figure out why I have to be on the Costs Sheet in order to run the UserForm

**rylo** · 01-17-2012, 01:33 AM

Hi

Easy way around that is to do something like

Please Login or Register  to view this content.

I think that will solve that loading problem.

rylo

**Thrawler** · 01-17-2012, 01:58 AM

I got it, I added WS.Range to it, and it fixed it

Thank you for all your help!

VBA Command Button Macro

LinkBack

Thread Tools

Rate This Thread

Display

VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Re: VBA Command Button Macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions