vbanewbie2
Last Activity: Oct 21 '10, 08:41 PM
Joined: Jul 18 '10
Location: nashville tenn
-
How to display another page's calendar events on my sharepoint page
I have a Monthly calendar on my Sharepoint site, I want my web part on my main page to reflect todays current events off a calendar on another page. How can I achieve this? -
Workbook | worksheet |cell | Text in Cell
oneshot 2010.xls | Jan-10 |$F$29 | JJV -
I tried the array but it did not work.
this is what my output looks like.
I need to find out how many Jan2010's there are in column B, How many Feb2010 there are in column b, etc
Workbook Worksheet cell# Text in Cell
oneshot 2010.xls Jan-10 $F$29 JJVLeave a comment:
-
coding / counting/ showing?
ok I have this code that populates every thing as it is supposed to do, my problem is counting....
I have a column (B) that gets populated with the follwing month/year info (I.E. JAN2010, FEB2010, etc).
I need to be able to count how many JAN2010 there are, How many FEB2010 there are, etc...
I have tried using a formula on the spreadsheet it self, but every time it gets populated it gets over written with... -
thank you sir, and hey it's great to finally have a face of whom I'm talking with. Just to let you know I got a "B" on the project. We now have to work on the tweaking of our projects = he gave us differnet things that he wants to see. Like the currency thing and expanding the search criteria. So far so good though.Leave a comment:
-
How to print caption so currency can show.
I am having trouble printing out the complete dollar amount of an item. for an item that costs $75.56
I only see 75 when I print it out. can anybody assist me with this.
My one line of code is below
Code:LabAmount.Caption = ActiveCell.Offset(0, 1).Value
-
Ok I was able to figure out how you added the items in the report form, pretty neat. I still have not been able to figure out the tab problem. also does the clients info have to be in the client spreedsheet in order to be printed on the report form. next week is turn in day. thanks again.Leave a comment:
-
I do have a couple questions if that is ok? Sorry I was on vacation but I'm back now and it looks pretty good. My questions are when the user accidentally types anything inside the COMBBclients it wants me to debug it (error), also the tab's seem to be all over the place. every time I try to correct them it goes right back to the way you have it is there something I'm missing? Last thing what are the macro commands to bring up the recoprt form...Leave a comment:
-
Point 1). I'm not sure if the name has to be split, but what happens if we only have a last name of the client.? Thats just the example we were given.
great point on the suggestions!!! I know K.I.S.S. (keep it simple stupid) right! I get it.
on the textbox length, why does it have to be so long, cant we just word wrap it and scroll down?
There is no real need for the header on the form, It's just...Leave a comment:
-
that lloks cool and the advice is great, both things I would have not thought of although I been informed to indent my code by my teacher. I like the calendar touch and adding a client list. SO every time the user adds a client in the txtboxes if they click add clients it goes to the client list and can be recalled at any time. oool. All the other entries in when you hit enter though do not go anywhere. Did I do something wrong on my enter command...Leave a comment:
-
ok GGEU, here it is again, I was told it was too busy and had to remove a few things. the things I was told to work on are the following:
1) i need any data that is entered into the form to go into the correct worksheet tab (i.e. if the date entered into the txtscheddate field is 1/1/2010 it will go into worksheet JAN2010.
2). I need a way that the user can print out a receipt. no matter who she is looking for. If the receipt...Leave a comment:
-
what if its based on a name? the user has all these rows of information each row containing a different name how would that get printed out.
Code:UserForm1.TextBoxDate.Text = txtname.value
Leave a comment:
-
sorry GGeu - not working ..... probably me.Leave a comment:
-
I noticed that you are using range("A1") but all my data gets added to a new row each time the user hits the enter key onb the user form. u have seen my project. how would i get to work fo me? same thing for the Printing a receipt problem. you are using a set cell. but if the client the user is looking for is in 151 how will that work?...Leave a comment:
-
Form data not going to correct date tab
When the user enters a date in the date field (txtbox) the data seems to be going to only one date tab (current month). I need the data to go into the correct month tab. another words if the data being input is from 3/1/2010 i need it to go to worksheet named MAR2010. If the data is from 1/1/2010 I need it to go to worksheet named JAN2010. any ideas? -
printing a receipt from excel
is there also a way to have the data listed within the spreedsheet go to a ticket or receipt (that looks just like the userform) in case the user needs to print it out? Just curious and looking for extra credit... I don't think anybody else would think about that one -
ok this one I figured out.... Brain is just fried I guess. I used a macro to get back to the form.
works great. thank you guys.Code:userform1.show
Leave a comment:
-
sny luck with my situation...Leave a comment:
-
is there also a way to have the data listed within the spreedsheet go to a ticket or receipt (that looks just like the userform) in case the user needs to print it out? Just curious and looking for extra credit... I don't think anybody else would think about that one.Leave a comment:
-
a way to get from excel to userform
here it is once again, my friends....Leave a comment:
No activity results to display
Leave a comment: