Hi,
This works great. Thanks for your efforts and help. Though I have a small
need as well.
The code gives the output through message box. Due to this I am unable to
copy the value (i.e) Output.
Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
ADULT OR MARRIED MINOR". Wha
check the attachment for custom filter on dates. in case you are using
background colors .
On Wed, Oct 27, 2010 at 10:52 PM, Rajesh K R wrote:
> hi ,
> First of all thanks for your reply u solve my problem very simply,i am
> very happy to get it solved so fast.in case we are using background
>
Hi! Roberto,
Thanks for your replies.
I need some time to fully understand the code and incorporate in my
project.
Regards
Learner
On Oct 28, 2:20 am, r wrote:
> On 27 Ott, 14:57, learner wrote:
>
> > Hi! Ashish,
>
> > This does not work. I pasted the code after clicking the form in the
> > emp
Hi All,
Trying to do some modeling where I would like Excel to create a random
number that is picked from a known distribution.
For example, I downloaded all S&P monthly data. Created a histogram
and know the distribution. Now I would like Excel to randomly
generate a number that follows the di
On 27 Ott, 14:57, learner wrote:
> Hi! Ashish,
>
> This does not work. I pasted the code after clicking the form in the
> empty sub with required changes of the names. But entering and exiting
> the TextBoxes + ComboBoxes do not execute the sub.
create
2 classes modules (the names are cCombo an
hi ,
First of all thanks for your reply u solve my problem very simply,i am
very happy to get it solved so fast.in case we are using background
colour what we can do in that case.I have one more doubt that is about
custom filtering using vba.eg: 1/10/10 to 10/10/10 .if it possible pls
write me.
onc
Hello everyone,
As you know that facebook is one of the top social networking site
today, I invite all of you to join us our page on facebook as well.
140+ members already liked this page. Suggest to your friends as well.
Here is the page link.
http://www.facebook.com/pages/discussexcelcom/160307
Thanks!
--
Sent from my Nokia phone
--Original message--
From: Sergio Abadesso
To:
Cc: "Dave Bonallack"
Date: Tuesday, October 26, 2010 11:01:40 PM GMT+0200
Subject: Re: $$Excel-Macros$$ Fwd: Practice
Hi Dave,
you have to consider that the property object.List(row, column) ha
can you give the attachment please
On Wed, Oct 27, 2010 at 7:57 PM, learner wrote:
> Hi! Ashish,
>
> This does not work. I pasted the code after clicking the form in the
> empty sub with required changes of the names. But entering and exiting
> the TextBoxes + ComboBoxes do not execute the sub.
Hi! Ashish,
This does not work. I pasted the code after clicking the form in the
empty sub with required changes of the names. But entering and exiting
the TextBoxes + ComboBoxes do not execute the sub.
A little digging suggests that "Class Modules" may take care of all
controls for exit event in
Hello,
Try using "Share Workbook" feature of MS Excel. This will also help
you in monitoring WHO changed from which OLD_VALUE to what NEW _VALUE
through hidden HISTORY worksheet.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certifie
Hi Paul & Learner
Sorry that's for VSTO guys - just got confused:
Try this:
Private Sub UserForm_Click()
Dim ctrl As Control
For Each ctrl In UserForm1.Controls
If TypeName(ctrl) = "TextBox" Then
With ctrl
If Trim(.Text) <> "" Then
.B
Interesting...
I've not come across this before.
I tried to pop it into one of my userforms, but it doesn't like the "Handles"
part
after the )... it expects the end of the statement.
Is there some Reference I need to include?
Paul
- Original Message
> From: Ashish Jain
> To: MS EXC
This is new for me.
Thanks,
On Wed, Oct 27, 2010 at 3:53 PM, ratu elissa wrote:
> try this:
> =TEXT(C3; "dd/mm/ hh:mm:ss")
>
> On Wed, Oct 27, 2010 at 4:26 PM, Anju wrote:
>
>> Hi ,
>>
>> Please help to format the dates in attached excel file to dd/mm/
>> hh:mm:ss. when i treid formatin
Hello Mr. Learner,
There are 2 ways to resolve your issue:
i. Sharing Event Handlers
Private Sub TextBoxes_TextChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles TextBox1.TextChanged, _
TextBox2.TextChanged, TextBox3.TextChanged
TextBox1.BackColor = RGB(255, 150
Sorry, but I don't think there is a "Userform_Controls_Change" event.
What you COULD do is to create a function to change the control.
Then, create an _Exit event for each control that calls the function
and pass the control name to the function.
That way, you can make 96 exit events, but only one
Hi Anju,
There is no formula required. You need to understand the concept.
First follow these steps and see if you understand the problem or need
explanation.
1. Close all Excel applications.
2. Open "Regional and Language Options" from "Control Panel".
(Start --> Settings --> Control Panel -
try this:
=TEXT(C3; "dd/mm/ hh:mm:ss")
On Wed, Oct 27, 2010 at 4:26 PM, Anju wrote:
> Hi ,
>
> Please help to format the dates in attached excel file to dd/mm/
> hh:mm:ss. when i treid formating the dates somedates format was dd/mm/yy
> hh:mm:ss...but i need as dd/mm/ hh:mm:ss for a
Hi! All Members,
I am a new member seeking guidance on a problem I can't solve.
A Userform having 96 Controls (TextBoxes + ComboBoxes) captures data
to create a worksheet. I need to change back color of each control as
data is entered by the user to indicate that the control is already
visited.
Hi Team,
I want a macro in MS word that will do the following.
It will first convert the upper case into title case and then replace every
connecting word with lower case.
*Example:* AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
*Required Output:* Agreement. The Adoption the Adul
Good!
On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey wrote:
> Ok, The solution is revised as per your needs. One thing the data scenario
> given by you has some conflict. Explained below:-
>
> 11/1/09 123456 -> duplicate
> 10/19/09123456 -> original
> 12/1/09
Hi I have an excel sheet with given below format
Region typeError descr
APACtype1 Error1
APACtype1 error1
APACtype1 error2
APACtype2 error3
APACtype3 error3
APACtype 3 error4
APACtype4 error 4
US type1 Error1
US type1 error1
US type1
www.tushar-mehta.com
Mr Tushar Mehta is an MVP, and his website has many useful examples on
graphs. once you open the site please go to charts and scroll down.
You will be able to see a map in different colors, which is named
conditional colors.
The web page had been moved so it didn't work proper
23 matches
Mail list logo
