Log in

View Full Version : Help me please...Words VBA



zach007
12-01-2005, 03:38 AM
Dear Experts,

I am using Ms Words and I would like to use a VBA to make "Item No", "Description", "Qty", "Price / Item" and "Total" as a column...However, there is additional button called "Add Rows"...Everytime I click "Add Rows" button, it will create new TextField as rows horizontally and also it will create rows on the Word Document...each time I fill TextFields on VBA, all text will be written into each TextField in the Word Doc...

Anyone could help me please how to do this..???...I almost 2 weeks got stack about this....Please help me for my assignment.....

(please let me know if you need a small DUMMY for this for your reviews and helps)

Thanks very much for your helps,

Jennifer

zach007
12-01-2005, 10:20 AM
Sorry...here is the file.

mdmackillop
12-01-2005, 06:18 PM
Hi Jennifer,
I see this is an assignment and under the rules of the site, we cannot give you a solution. If you would like to post your code, we could offer some guidance.
Regards
MD

zach007
12-01-2005, 08:21 PM
I really need your help to have that codes..(I dont know the meaning of "under the rules of the site")...However, it is up to you if you would like to post this code to public, I have no problem at all...The most important thing is I can have this code for my due assignment...

Thanks,

Jennifer

zach007
12-01-2005, 08:23 PM
Sorry...you dont need to worry about how to showing the form and any other codes...I just need how to add rows automatically when I clicked "Add Rows" and when I clicked "Calculate" it will calculate the "Total" fields...that is it...no more...

Please helps me anyone who are expert person..

Thanks very much,

Jennifer

TonyJollans
12-02-2005, 01:22 AM
The most important thing is I can have this code for my due assignment

Sorry, Jennifer, but ... No, the most important thing is that you do your own assignment.

mdmackillop
12-02-2005, 01:30 AM
Hi Jennifer,
Most of the code you need can be found by recording appropriate macros. You will need to count the number of rows in your table and use this variable to determine where you select before running the code lines.

zach007
12-02-2005, 02:53 AM
I just want to let you know everybody....this is "just a part" of my big assignment.....all parts were done, my question is only small part of this...and as you know that the file attached is not actual file...I create an easy dummy to you easier to give me helps..... and this is not university assignment..I am trying to help my father in preparing administration for his small shop....Please understand for this....If I know I would not ask to you and what the purpose of this forum if this forum could not provide helps...???

Thanks very much,

Jennifer

fumei
12-02-2005, 03:33 AM
This is nonsense. I could believe this if the attached file HAD some code. It has NO code it. Not a speck. There is nothing there to indicate you tried anything at all. We are not going to help anyone who does not even try.

If you try to get something to work, and actually have problems...then sure we will help.

You do not have a problem. How can you have a problem with code when you never even tried to make any code? Try looking in Help. Try to actually DO something. If something does not work, or you want assistance in understanding something we can help. But we sure are not going to write off some code for you.

fumei
12-02-2005, 03:39 AM
Besides, this site does not "provide" anything. We share.

zach007
12-02-2005, 12:32 PM
Because I am newbie in VB and I just now the basic....if I know about all of this code...I would not ask to this forum...I really just create a dummy just like that because if I give you with my messy codes you will be confused...I make it like this to make you easy to understand...What's wrong with you guys????..Is this a forum? or this is a argumentation forum...???...I just need your helps from you about this "part" of my whole project....

mdmackillop
12-02-2005, 04:52 PM
Hi Jennifer,
Please post your "messy" code. It's where most of us started out, so I'm sure we can follow it
Regards
MD

fumei
12-02-2005, 09:00 PM
Precisely. Jennifer, we are not trying to make you feel bad. It is an assumption on your part that we would confused by your code. You are saying you are doing us a favor by not showing us that you are doing anything?

You are asking us for assistance. Why? Because it likely that someone in the group here CAN help you. That someone in this group is not going to be confused. I can pretty much guarantee that if you are a newbie, then you are not capable of writing anything that is going to seriously confuse.

This forum, as has been stated, is not to just to give out solutions because someone has asked for one. Why should we? Why should any of us do the work for someone? We do this for fun, for sharing. Sharing is a two way street.

ALL of us, as MD said, started out with messy code. ALL of us started out asking what we may think of now as dumb questions. But we worked at it. By working at it, we gain enough respect that people DO freely offer help.

So, as I have been trying to get you to do....

Post your code - tell us where it is not working. I absolutely guarantee we can help. If you get error messages remember to tell us what they say.

Look up Help. There is a HUGE amount of information in Help. There are lots of examples of code you can use in Help. When you put in some code (or see any), put your cursor over a word and press F1. Help. It has a lot of stuff.

Bottom line? Give us something...we will give something back. Give us nothing, which looks like trying to get something for nothing....well, that is what you get.

Messy code is good. It means that YOU are trying. Some of us are quite.....picky, and we love to point out where messy code can be made into neat, efficient, and WORKING code. We can help, but you have to give us something. That something is only the sense that you are contributing.

Up to you.