VBA Macro for font styles #2
I'm trying to do this within the same macro, so I shouldn't hav
problems with the variable disappearing.
All my macro is trying to do is the following:
When I press ctrl+shift+O, the style of the selection changes to on
thing. When I press it again, it changes to something else. Once
cycle through the four options and I press it again, it just gives m
back what was there originally and the cycle starts over.
The macro is not complicated at all. I guess I just need a functio
that returns the font style of the current selection, but I haven'
been able to find one yet.
Can an...Tick box how do i? plz
I have a spreadsheet that I want to put a tick box coloumn into to show
whether I need to reprocess an item. Can some kind person tell me how thank
Got it sorted thnx
> Hi Folks,
> I have a spreadsheet that I want to put a tick box coloumn into to show
> whether I need to reprocess an item. Can some kind person tell me how thank
A co-worker, who has since moved on to greener pastures, coded the following
for me. I use it to explode the contents of partlists, where all the part
numbers of a particular type are stored in a cell. Now I am receiving the
lists from new sources, and need to update the code a bit, something I am
completely unfamiliar with.
In this statement If InStr(strNewNumber1, " ") > 0 Then how would I also
include (TAB) and other pseudo space charecters, so it will work on files
produced by people who refuse to use the space bar?
Dim strRow As Str...Creating a Linked Drop Down Menu
I have a spreadsheet, which tracks inventory on "sheet1" it has columns such
as "model" and "serial number" for example. On "Sheet2" I would like to be
able to create a drop down menu that lets me select one of the entries from
the "model" column on "sheet1". This I seem to already have accomplished and
it works fine, i can pick any of them from a drop down list. However what I
would like it to do autoamtically as well, is grab the applicable serial
number and put it in the next cell. I have done this before...combo box to select a table
I have written some VBA code in a module which works without fault. However,
I want to create a combo box on a form to select a table (from the available
tables) so that the name of the table can be passed to this VBA code, but I
cannot remember how to create this combo box. Any ideas anyone?
Life is like a toilet roll - the closer you get to the end, the faster it
On Fri, 12 Feb 2010 05:10:04 -0800, Simka
You can either select from the system table MSysObjects, or write some
VBA code to populate the listbox from the T...Xbox 360 extender keeps dropping off and is very slow
The connection wizard went fine, it loaded all my photos, music,
Once that was all done, the system lags really badly and keeps loosing
the connection. If you wait long enough to navigate the menus it will
play a video ok but it takes forever to get that far. Pictures
normally crash it.
I have a hp laptop connected via wifi to my sky router which is hard
wired to the xbox.
Any help would be greatly appreciated.
can you test with the laptop hardwired to the router to see if the problem
disappears? G or N wireless? what laptop?
On Sun, 10 Jan 2010 18:18:4...Trouble with VBA loop
I am trying to buile a funtion that counts the number of days I will reach a
set dollar amount based off of what I am currently spending per day. The code
is as following:
Public Function DayAppropriatedAmountWillBeMet(BeginDate As Date,
CurrentSpent As Currency, AppropriatedAmount As Currency)
'Function will figure what day Appropriated Amount will be reached based off
current spending _
or when you will run out of money
Dim DaysPassed As Double
Dim M As Currency
Dim U As Currency
Dim MoneySpentPerDay As Currency
Dim Counter As Integer
DaysPassed = DateDiff("d&...drop-down confusion
I have looked all over and even tried the contextures website. I am using
excel 2003 and would like to create a drop-down box on a time sheet that
everyone will save on their local machines. I would like to link our client
database to the drop-down and store that file on our server. This file will
change every week. I am not fussy on what i save the database as. It will
only contain a client number and name. Is this possible? I have seen that
you can link to another spreadsheet that is open but most likely the file
will be closed and just in a specific folder on the server. Please help...Drop down lists and you
Is there a drop down list style that will let you leave a blank line i
the drop down list that you can type into?
ie. I have a drop down list of hotels and I link them to other pages i
the workbook, but if I have a hotel that is not on the list, I cant typ
into the cell and have it link to other pages. But the listed hotel
link just fine.
I have tried using standard forms, active x forms, and list validatio
as well, but nothing works. Is it even possible
Message posted from http://www.ExcelForum.com
If you're using dropdown lists created using data
validation just disable the err...Printing text box with hidden text
I'm looking for some help with a problem I'm having with a "drawing
tools" text box. I have a form that contains a text box. The problem
is when a user types into the text box and exceeds the box, they can
continue to enter text past what appears on the displayed box. When
the form is printed out, what ever was not displayed on screen is
So, is it possible to limit the text box to be locked from scrolling?
Or, is there a way to get Excel to print the entire contents of the
Thanks for any help on this quirky problem.
Anyone else experience thi...Access text box
I was trying to add text boxes to my database in form design view, which
worked fine up until the moment when i was back in form or table view. For
some reason when I add detail in one of the cells of the new column it was
automatically copied to every other cell in that new column. This has only
been happening with the new columns and the ones I created using the wizard
when starting the database seem to be working fine. What can I do about this?
On 25 mrt, 12:19, FernP <Fe...@discussions.microsoft.com> wrote:
> I was trying to add text boxes to my database in form desig...Movement of cursor within a drop down list
When we type a letter in the cell, the cursor should move to the word
starting with that letter in the drop down list. How this can be done?
If you are using a Data Valadation drop down try this.
Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.
Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.
Should take...Drop-Ship Blanket PO to multiple customers
Here is the scenario my customer has:
I issue a blanket PO to VendorA for 7000 widgets for the month of February.
Then we need to issue some sort of document (I assume a PO) for distribution
of those 7000 widgets on different days throughout the month to various
880 to be drop shipped to CustomerA supply in Florida on Feb 4th
880 to be drop shipped to CustomerB on Feb 6th
880 to be drop shipped to CustomerC in West Virginia on Feb 10th
Right now I am issuing a PO for the 7000 bags to VendorA...then cancelling
And issuing drop ship PO's f...Drop user or alias before dropping login
I am trying to delete a user, and I get this error:
Login is aliased or mapped to a user in one or more databases. Drop the
user or alias before dropping the login.
GO to SQL server --> logins and select the user and open check the
properties of the login and see what database access the users has. If any
uncheck all the database access and drop the user.
Also make sure from the GP front end you have unchecked the company access
If still you get errors go to each database on the server and make sure they
are not in the users list in the databases.
...In Excel vba how do you Launch code a standalone Module from a Form or other Module ?
I can create stand alone modules in Excel vba by clicking File New Module or
How can I run the code in those stand alone modules from another module or a
Form that has its own code?
Thanks for any help.
If you're talking about "New Project" from the VBA File menu,
this create a new VBA project that is used to create COM Add-Ins,
a discussion of which is beyond the scope of a newsgroup reply.
In general, you want to use the Insert menu to create a new
module in an existing workbook.
In VBA, there is no such thing as a "stand-alone" module; all...drop down lists #6
thanks to some members of the forum i now have drop down lists on my
i have to input say 20 peoples information in a month and i was
woundering if i could set it up so that i can use the one drop down
list to deal with all 20 peopels, so for example..
person 1 wants 'shoes', click cell a2, click on shoes from table and it
person 2 wants 'hats', click cell a3, click on shoes from table and its
at present i can only control one cell, with one drop down list, can a
condition on something be places so that i can save my spreadshe...Diagonal Lines appear in some text boxes
After creating and test printing (to an Adobe pdf) a large poster (no
it was printed at the local FedEx Kinkos, most of the text boxes had a
diagonal line printed from top left to bottom right. This line did not show
in any "print preview" or on the finished pdf. Any thoughts? John
Adobe has support documents
Mary Sauer MS MVP
"JMcNulty611" <JMcNulty611@discussions.microsoft.com> wrote in message
news:03AF747E-...filter in combo box
I am trying to filter information from one combo box to display into another
The first displays the fields Element, Reference
The second Sub-Element, Reference
Whatever element the user selects in the first combo box i need the second
one to only display the sub-elements with the same reference.
Can I do this???
Any help appreciated
"Nathan" <Nathan@discussions.microsoft.com> wrote in message
>I am trying to filter information from one combo box to display into
> combo box.
> Th...Combo box Filter
Hi All, I have a form that displays three columns labelled Science,Maths and Languages. Below each column is a command button "NewRecords". Upon click the button a new form (frm_NewRecord) opens upallowing the user to enter a new record. This form (frm_NewRecord)contains a combobox which holds all the books. What I want to do iswhen the user clicks on say New Records for the science column thenthe combobox in frm_NewRecord should only display the books relatedthat that category likewise for the other buttons.Any suggestions??Thanks On Mar 27, 7:09 am, "Asif" <asifhashm.....Cannot activate worksheet using VBA. "Subscript Out of Range" error.
I have written the following test program which does not work. Does
anyone know why it doesn't? I want to copy a column from one workbook
and paste it into another. I am now getting desperate as this is
holding up work. Here is the code:
Worksheets("ABNLookup").Activate 'THIS IS WHERE IT CRASHES
When I try to...ListBox MultiSelect VBA Issue
I'm having difficulty with this code... I'm trying to go through and
reference multiple columns for each item that is selected in a list
box. When I run this code it only executes one time and removes one
item when I have two items selected. Code is below. Let me know if
have any ideas.. - Thnx
Dim PstClsNme As String, PstClsID As String, PstClsAssignDte As Date,
tpe As String, rw As Variant
If List0.ListCount = 0 Then
MsgBox "You must select at least one item to assign!",
For Each rw In List0.ItemsSelected...Partially invoicing a Drop-Ship Order Linked to a Drop-Ship PO
Can you partially invoice a drop-ship order in SOP that is linked to a
We received an invoice from one of our vendors that was for a drop-
ship PO we issued to them. They did not ship the complete
order...only a partial. We matched the partial invoice to the drop-
ship PO and processed it, but now need to invoice the customer for the
In the drop-ship order in SOP, it shows the quantity fulfilled for the
line item as the amount from the vendor invoice, but in the Quantity
to Invoice field, it shows the total quantity ordered when the
customer placed the order.
Is the...Paste Special drops cells from Word and Excell
Our church is using Publisher 2003 to do our bulletin and newsletter. When
we try and use Paste Special to paste the calendar from Word 2003, it drops
the last row of cells bottom of calendar (they do not show up in Publisher).
If we go back to Word 2003, new document, and paste, everything is there.
The same thing happens when we try to Paste Special from Excel 2003. It
drops the last column of the Excel sheet.
Any suggestions on how to fix this? The calendar and Excel sheet are put
together by another individual ( not the secretary) and emailed to the church
The secre...Alignment of Combo Box Text
I have found http://www.lebans.com/verticaljustification.htm that applies to
text boxes and labels.
Are there any references to vertically center COMBO BOX text?
"PosseJohn" <PosseJohn@discussions.microsoft.com> wrote in message
>I have found http://www.lebans.com/verticaljustification.htm that applies
> text boxes and labels.
> Are there any references to vertically center COMBO BOX text?
You just needed to look farther on Stephen's site:
http://www.lebans.com/justicombo.ht...Line chart - time series
I'm using VBA in Excel 2007 to plot time series as line charts (i.e., data on
Y axis, dates on X axis, ChartType = xlLineMarkers). My data's not in a neat
"block", so I can't use the ChartWizard or SetSourceData methods. For Y-axis
data I'm using:
..SeriesCollection.Add Source:= [a range variable with my data]
How do I set up the X-Axis so that I can format the dates? I've tried:
..Axes(xlCategory).CategoryType = xlTimeScale
..Axes(xlCategory).CategoryNames = [a range variable which is a column of
However, Excel treats the Categor...