Hi Steve,
I think the simplest way would be a two-step approach, something like:
A = MsgBox("Do you want to enter a date?", vbYesNo)
If A = vbYes Then
B = InputBox("Enter Date")
End If
You may want to error trap for a non-date entry.
Regards - Dave.
Date: Thu, 16 Apr 20
u can use input box for entring a date while running macro
On 4/16/09, Steve wrote:
>
>
> Hi,
>
> I need to insert a message box in the middle of a macro that will
> request the user to enter a "Start Date" or give them the option to
> skip it and
> let the macro continue running. Any help would
Hi,
I need to insert a message box in the middle of a macro that will
request the user to enter a "Start Date" or give them the option to
skip it and
let the macro continue running. Any help would be deeply appreciated.
Thanks,
Steve
--~--~-~--~~~---~--~~
-
Hi Surya,
As long as your data is in the format provided in your sample file, the
solution in the attached will be ok.
Regards - Dave.
Date: Wed, 15 Apr 2009 12:59:11 +0530
Subject: $$Excel-Macros$$ Color Conditional Formatting
From: suryaprasad...@gmail.com
To: excel-macros@googlegroups.co
Rahul --
There is an area on my web site to help you begin ...
Getting to Know VBA
www.beyondtechnology.com/vba.shtml
-- particularly for you ...
Beyond that, I can recommend anything written by John WALKENBACH
... he does an excellent
Hi
I want excel dumps for certification
advance excel 2007
plz help me???
On Wed, Apr 15, 2009 at 9:58 PM, Harmeet Singh wrote:
> Formula dekh ke chakar aa gaye.hahahahaa
> I must say awesome work.
> Cheers.
>
> On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey wrote:
>
>> Hi Surya,
>>
Formula dekh ke chakar aa gaye.hahahahaa
I must say awesome work.
Cheers.
On Wed, Apr 15, 2009 at 8:33 PM, Dilip Pandey wrote:
> Hi Surya,
>
> Please find the solution attached. I have tested it also and it is working
> fine.
>
> Note: You may find that some of the time entered by you i
First of all, we'd need to see the code to give an accurate assessment.
There are several techniques that can be used to change the cell height.
The technique you selected could be the culprit.
Second... you say that "all the other cells on the worksheet are locked
apart from this one and the shee
Hi
pl find the file attached, soultion is, first replace "-" with " " (space)
then
put a formula next to date row, that is hour(a1), it will fetch hour from
the date n time part then
apply conditional formatting on hour, if hour is greater then 7 then it will
color the cell.
regards,
Deepak Rawat
Hi Surya,
Please find the solution attached. I have tested it also and it is working
fine.
Note: You may find that some of the time entered by you in the earlier rows
have changed, it is because of the testing done.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 981092974
Your reasons seems to be very much valid Paul - I was just cautioning - but
here you already have a check after every save - thatz really good.
On 4/15/09, Paul Schreiner wrote:
>
> There's LOTS of reasons for wanting to do this.
> Hmm... I take "exception" to ddadmin's comment
> "writing a code
Hi,
use this code
Tools --> Referance
Add
Microsoft Internet Controls
Microsoft HTML Object Library
Dim brs As InternetExplorer
Sub IE()
Set brs = New InternetExplorer
With brs
.Visible = True
.Navigate "http://Google.com";
End With
Do While brs.Busy Or brs.ReadyState <> READYSTA
please check the attached example and let me know is that you needed
thanks
Regards
Santosh Bahuguna
On Wed, Apr 15, 2009 at 11:46 AM, kris wrote:
>
> Hi All,
>
> I have a requirement to work with internet and to enter some text,
> need to select option buttons, need work with check boxes an
Hello,
I have a macro to reformat the height of a group of merged cells which
makes up the "comments section". All the others cells on the worksheet
are locked apart from this one and the sheet protected. However when
the macro runs to re-format the box height, the cell becomes locked
disabling t
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
check the article above for color conditional formatting with an example
(steps 3 and 4). Tell me your specific case so that I can tell you what to
keep in the formula or cell value.
On 4/15/09, Suryaprasad.bv w
Hi Surya,
See attached file.
One suggetion, it would be easy to apply conditional formatting if you
change the format for column A.
On Wed, Apr 15, 2009 at 12:59 PM, Suryaprasad.bv
wrote:
> Hi Guys,
>
> Can any one help me on the conditional formatting .
>
> Cheers
> Surya
>
> >
>
--
Than
Dilip, How can u read my mind. awesome..
On Wed, Apr 15, 2009 at 3:51 PM, Dilip Pandey wrote:
> Rightly said Harmeet,
>
> Because if the file is not attached, then we have to do "Data Clensing" &
> "Data Processing"... and it involves considerable time dedication, which
> will ultimately res
Dilip, Than a lot for saving my time.
Zohair, I think u should appreciate Dilip's effort if that helped you.
On Wed, Apr 15, 2009 at 4:12 PM, Dilip Pandey wrote:
> On Behalf of Harmeet Sir...!!
>
> Hi Zohair,
>
> Pls find the sheet attached with the solution. There was the issue only
> related
hi,
see this link :
http://www.dailydoseofexcel.com/archives/2004/09/22/automating-internet-explorer/
with regards
Bala
On Apr 15, 11:16 am, kris wrote:
> Hi All,
>
> I have a requirement to work with internet and to enter some text,
> need to select option buttons, need work with check boxes
There's LOTS of reasons for wanting to do this.
Hmm... I take "exception" to ddadmin's comment
"writing a code around save is not recommended"...
I use the Workbook_BeforeSave event in many of my applications.
(I'm currently maintaining about 130,00 lines of VBA code!)
Here's a couple of uses:
1
Srinivas,
Oh WOW.. I don't think you're getting the power of this tool AT ALL!
Copy/paste makes a DUPLICATE of the data selected.
The duplicate can then be modified so that it is then DIFFERENT than the
original.
This tool seems to act like a web-cam, in that it shows you what the area LOOKS
l
Hi Ayush, thnks for sharing this information, II am using your idea to
update a table which contains employee and amounts column, here I need one
more help I have a chart and I need to colour few bars if the amount is
greater than 50 or 40 USD every day, and I want help where in if the table
is upd
This is Rahul Kumar Sureka , I want to learn from the start the basic
fumctions of excel and also MACRO's as it is useful in my job . My
basic requirment is PIVOT Tables and learning Macros Could you guys
please help me out of this.Waiting for your prompt reply.
--~--~-~--~~---
Rightly said Harmeet,
Because if the file is not attached, then we have to do "Data Clensing" &
"Data Processing"... and it involves considerable time dedication, which
will ultimately restrict and shorten our time that can be utilised to give
solutions to others... right harmeet??
Pls attach the
Thank you!
However this is a link describing a code to create palindromes instead
detect them.
Luciano
On 14 abr, 20:28, ddadmin2009 wrote:
> check the below
> linkhttp://funwithexcel.blogspot.com/2009/04/macro-to-write-mathematical-...
> You might tweak or extend from there.
>
> On 4/14/09, L
Hi All,
I have a requirement to work with internet and to enter some text,
need to select option buttons, need work with check boxes and to click
the buttons and all.
Could you please send me how to do it taking Google.com as an example.
Waiting for your reply.
Thanks & Regards,
Krishna.
--~-
Hi Guys,
Can any one help me on the conditional formatting .
Cheers
Surya
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Tex
havent heard, still waiting for the answer, wake up...
--- On Tue, 4/14/09, shannu shannu wrote:
From: shannu shannu
Subject: Urgent help filter macro
To: excel-macros@googlegroups.com
Date: Tuesday, April 14, 2009, 10:16 AM
Hi All,
Can anyone help me in creating a macro.
28 matches
Mail list logo
