Changing Multiple Tab Colors based on lookup value VBA?????I am very new to VBA and am looking for help with the following
problem:
My workbook contains ten tabs that link back to a central sheet. I
would like the color of each tab to change (Green vs No Color) based
on whether a certain cell in each tab meets a certain requirement.
Example: If cell (V1) in tabs 1, 2 & 5 = "Yes" then color the tab
green else no color. Note, (V1) is a lookup function that gives a
value from the central sheet. The remaining tabs (3, 6,7,8,9 & 10)
would have no color since the lookup function is not equal to "Yes".
Note, the central ...
Modifier with VBA`Our company is recently trying to do some changes on the Collection mgmt
windows. Its being suggested we go tthrough via the Modifier approach.
We are using GP 8.0; so we installed the VBA from the additional product
suite but when I go to Tools->Customize I find the VBA menu items disabled.
So going through this newsgroup it was suggested that an additional
license[site customization license ] is required . Is this true?
AC
AC:
If you are a customer and want to do your own VBA modifications, you must
buy the full Modifier with VBA product. If you are a partner who is doing
the ...
vba project passwordHello I created a form about 2 years ago and I put a password in the vba
project. Today I was asked to make a change and I cannot remember the
password. Is there any way to do this? Please I hope so.... thanks
Try searching for "free excel vba password open source download" on Google.
--
Rich Locus
Logicwurks, LLC
"Wanna Learn" wrote:
> Hello I created a form about 2 years ago and I put a password in the vba
> project. Today I was asked to make a change and I cannot remember the
> password. Is there any way to do this? Ple...
running some VBA code in response to data entered in a cellhello again
Can anyone tell me if it is possible to trigger some VBA code when a number
entered in a particular cell on a worksheet is less than the number in
another cell?. I dont know if cells have events linked to them such as mouse
down etc
Thanks
Ian
Mantrid
You could use the worksheet_change event like so. Checks a value in A1 and
if below 10 it colours B1 red
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
If Target.Value < 10 Then
Target.Offset(0, 1).Interior.Color = RGB(255, 0, 0)
...
VBA on CitrixOur remote user are accessing GP via Citrix (on Windows 2003 server) and we
also use VBA to add custom form.
Remote user are grouped as 'gp users' and I had grant Full Control right 'gp
users' on following registry:
* HKEY_LOCAL_MACHINE- Software- Microsoft- Great Plains
* HKEY_LOCAL_MACHINE- Software-Microsoft-Office
* HKEY_LOCAL_MACHINE- Software-Class-CLSID
* HKEY_CLASSES_ROOT-CLSID
* HKEY_CLASSES_ROOT-Interface
* HKEY_CLASSES_ROOT-TypeLib
everything work fine until recently I added a form that uses MSFLXGRD.OCX
which I had properly registered the ocx.
When remote use...
help with VBA retrieveglobals9can anyone help me with using this dll, I cannot find any documentation
anywhere as to how to construct a connection sting using this?
MAny thanks for any help
RetrieveGlobals9 was updated to work with the new login handling for v9.0.
It no longer returns a connection string, it now returns the connection
itself.
Please use the links at the bottom of this KB Article to download the dll
and the documentation.
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;913341
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynam...
VBA Question #7I have a little problem. I need to write a VBA. I have a button that will
print four letters that are located in a seperate worksheet. Currently I
have a macro that goes to that worksheet and prints all four. But I want to
have a pop-up that will ask Which letter they want to print. I believe that
this is possible, but i need some help developing it. Any help would be
appreciated.
Thank you
One way would be to record 4 different macros - one to print each
letter, in my example I have called them Print1, Print2, etc. Then
attach the macro below to your print button:
Sub Pintit(...
EOF in Excel VBAHi Everyone,
I have recorded a macro that will pivot some data. Each
month I get a fresh batch of data that needs to be
pivoted in the same way. Each month though the amount of
records increases, although the format stays the same, so
at the moment I go into the VBA code and change the
number of rows that excel with pivot tom allow for the
new number of records. Is it possible to uise some code
code to tell excel to look untill there are no more
records to know how much data to pivot.
I don't know a great deal about VBA just stuff I've
picked up along the way so I won't ...
VBA QuestionI have written a VBA Panel with one of the buttons being a page upand
page down button using the following code
Private Sub CommandButton26_Click()
On Error Resume Next
With ActiveWindow.View
Call .GotoSlide(.Slide.SlideIndex + 1)
End With
End Sub
The code works in the slide view but not the slide master view. What
am I missing?
What would you expect it to do in Master view?
(There are no slides to goto in this view)
--
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_...
VBAWhat does the acronym VBA stand for? I cannot find it in Excel's help
menu.
---
Message posted from http://www.ExcelForum.com/
Visual Basic for Applications
"1NCaNon" <1NCaNon.zb64y@excelforum-nospam.com> wrote in message news:1NCaNon.zb64y@excelforum-nospam.com...
> What does the acronym VBA stand for? I cannot find it in Excel's help
> menu.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
...
chart area size vbaHow can I set the chart size of an existing active/selected chart?
I tried this withing a sub routine:
With ActiveChart.ChartArea
.Width = 5
.Height = 3
End With
And get the error message: Unable to Set the Width Property of the
ChartArea Class
Any help is appreciated.
Hi,
If the chart is on a worksheet this will work, although your chart will
be very small.
With ActiveChart.Parent
.Width = 5
.Height = 3
End With
Cheers
Andy
kaonashi@gmail.com wrote:
> How can I set the chart size of an existing active/selected chart?
>
> I tried this withing a sub routi...
VBA #2trying to get code to pick up null values in lines i'm copying from a
coupole of worksheets and pasting and move the existing counter i have to
the next line that contains data before i write it to another worksheet
What code do you have now, and what problem are you having?
spota wrote:
> trying to get code to pick up null values in lines i'm copying from a
> coupole of worksheets and pasting and move the existing counter i have to
> the next line that contains data before i write it to another worksheet
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://...
VBA Doorway to Database PropertiesHow do I access the data in the Database Properties window from VBA?
I have searched the help files and numerous properties via the Immediate
Window, but cannot find an opening to the underlying Database Properties in
the object model. I can access the ShapeSheet, but that has no info on the
relationship itself. I can get the field list via .Text in the individual
Entities, but not the table name. Where is all that stuff found? (I suspect
it might be through the UI, but I've had no luck there, either.)
My diagram is a reverse-engineered Access 2003 database, with over 280
relations...
Convert to VBA code?I originally had a button that, when clicked, would run a macro. I now
need to write the VBA code for that instead, and need help. Here's what
I am trying to accomplish:
My form contains a field called TimeStop which contains Date/Time in the
format of 3/22/10 10:05:06 AM
I need to populate a field called DateStop and the value of that field
will depend on the TIME portion of TimeStop. If TimeStop is between
12:00:00 AM (midnight) and 5:00:00 AM, then I need DateStop to be the
current date - 1. Otherwise, I need it to be the current date.
Here's my stab at it, but I ...
VBA conundrumOk, so here's the problem...
I prompt the user to enter a size (say 9,000), then I subject that number to
a condition. If size >=0<10,000 Then
This is where I get confused. First, I would like to determine whether
9,000 is in the range that I've specified. Ok, so it is. Second, I want to
take the user's number (9,000) and determine how many times a default number
for that range (3,500) goes into 9,000. 3,500 goes into 9,000 twice so
numbers "1" and "2" would comprise column 1. Third, I want to display the
default number, 3,500, in a second col...
Error on simple VBA codeI am trying to set the post to GL flag as checked on inventory batch window.
The code is very simple:
Private Sub BatchID_Changed()
Me.PosttoGeneralLedger = 1
End Sub
I tried this same code with different events but the error is the same.
The error I am getting is Run time error 1007. Unsafe operation. An attempt
was made to set a value which violates the application's business logic.
What could be the issue here and how can I resolve it. Thank you.
KT:
The problem here is that a bunch of nested code runs behind the BATCHID
button change event. I scripted it so you can see:
*****...
Possible VBA help needed
Hey guys, i'm new here and need some Excel help.
Using Office 2003.
I've got a long list of names (we'lll call it List A) with separate
columns for various data like SSN and geographic location, etc. I've
got another list (List B) of names which I'm trying to compare it to.
Ultimately I want to come up with one MERGED final list but obviously I
want to avoid having any duplicate entries.
The problem is further excerbated by List A being sorted in
alphabetical order by last name, first name. List B is sorted by first
name, last name. This obviously makes the compari...
update details using vbaHi
I have a validation list over 2 cells which when a specific word is selected
from the list then I need the word 'Please specify:' to be shown in another
cell but when any other word is selected from the list is is empty then I
dont want the 'Please specify:' to be visible.
Can anyone help.
I have tried the following but does not work and I dont know why.
Private Sub Worksheet_selectionChange(ByVal Target As Range)
If Target.Address = "G26" Then
If Range("G26").Value = "Other" Then
Range("E28").Value = "P...
from vba to vstoHi
Im trying to convert my vba code to vb.net and have a problem. I have a
function that returns the default file path for the usertemplates, another
one for the workgrouptemplates. I need to know both because I want to create
documents based on templates that are placed in theese diredtions.
vba
getTemplateFilePath =
Application.Options.DefaultFilePath(wdUserTemplatesPath) & "\"
I have found the Globals.ThisAddIn.Application.Options.DefaultFilePath but I
dont understand how I can specify to make it return the usertemplatesPath?
does anyone know?
It's ve...
Search function in VBAI need help setting up a search function in VB - basically it would ru
like this:
The user presses the "Search" button, which brings up a dialogue bo
that they input their information into. They press "Ok" and the searc
macro finds the info they need. Any help would be appreciated!
Thanks
--
Message posted from http://www.ExcelForum.com
Hi
and why not use the build-in dialog?
--
Regards
Frank Kabel
Frankfurt, Germany
> I need help setting up a search function in VB - basically it would
> run like this:
> The user presses the "Search" button, which...
Print dialog box using VBA in excelHi Everyone,
I like to add a print button (that will select several worksheets and
print them) in my excel worksheet. I have recorded my action using the
macro recorder the problem is I can't select the printer everytime I
run the macro it print in the background without asking the user to
select the printer and uses the default printer.
Can anyone help?? I just want the user to be able to select the desired
printer every time before printing.
My current code:
Sub Print_All()
Sheets(Array("Sheet 1", "Sheet 2", "Sheet 3", "Sheet 5)).Select
'intent...
java message with VBAYou can import www site with Excel, but only those parts which writes in
HTML.
Java applet seems to disappear.
Is there any possibility to intercept the java message (text) with VBA
<SCRIPT LANGUAGE="JavaScript">
function choiceCheck() {
var nrTable=new Array("119b/05",-1);
var timeTable=new Array("07:16","09:50",-1);
var dateTable=new Array("23-06-2005","23-06-2005",-1); � so on
This part of data will not appear
Any suggestion
Thanks
Don't see how, as that is an instruction to HTTP to run that c...
vbaHi,
How can I populate the Trx Dimension Code Description in Analytical Payables
Trasnaction Entry window using vba? I have put the correct value in the Trx
Dimension Code but after running IM the Trx Dimension Code Description is not
updated. I need to go the grid, press tab before it will display the value.
Is there a way to manipulate it using vba?
Thanks,
Mel
Hi Mel
Analytical Accounting and Integration Manager standard adapters don't play
well together. have a look at this post for more info.
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2009/09/0...
VBA + Excel Performance: your feedback requestedHello all - The Excel development team is currently investigating a number
of scenarios where VBA macros take longer to run in Excel 2007 than in
earlier versions (i.e. Excel 2003).
I am looking for folks who believe they have run into a VBA performance
slowdown and who would be willing to share their code/workbook/steps to
reproduce the issue. Given the enormous variety of solutions people build
in Excel using VBA, we feel it is important to survey the XL community to
collect a range of examples that are important to XL users.
Specifically, we are looking for VBA code that takes long...
Turn off Outlook spell checking of messages with vbaIn developing an application for Word which sends e-mail messages using
Outlook, I came across an issue that I have not been able to resolve.
Hopefully someone will have a plan :)
With Outlook's options configured to spell check the message before sending,
each message processed creates the message 'Word finished checking the
selection. Do you want to continue the remainder of the document' which
requires user intervention. Clearly if the option is switched off in
Outlook, the message doesn't occur. As I have no control over whether users
have this option set o...