Thank you Ashish, didn't think of that... sometimes the simplest answer is
the best!
Cheers,
Christos
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RU
if its a simple data validation then you can do it directly like
range("a1").value ="xyz"
On Fri, Feb 13, 2015 at 3:32 PM, Christos Alekopoulos <
christosalekopou...@gmail.com> wrote:
> Sorry I was not specific and sorry again I wish I could share the file...
> It is just a dropdown list on a c
Sorry I was not specific and sorry again I wish I could share the file...
It is just a dropdown list on a cell.
I have the VBA that replaces the values of cells but the thing is that
there are a couple of cells that are populated via those lists and the
values won't change. Unfortunately, I a
is it on cell , activex combo box ?.. Can you please share the sample file
On Fri, Feb 13, 2015 at 3:08 PM, Christos Alekopoulos <
christosalekopou...@gmail.com> wrote:
> Just a quick question guys...
>
> Do you know how I can change a value of a dropdown list using VBA? I tried
> to record a mac
Just a quick question guys...
Do you know how I can change a value of a dropdown list using VBA? I tried
to record a macro to see the code but with no luck.
Thank you in advance
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
It is more clear now...
Cheers!!
On Tue, Feb 10, 2015 at 7:00 PM, Christos Alekopoulos <
christosalekopou...@gmail.com> wrote:
> Thanks Vabz but I don't want just a function that replaces any value. My
> post explains fully what I needed!
> Cheers
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Welcome Christos...
On Tuesday, February 10, 2015 at 4:52:30 PM UTC+5:30, Christos Alekopoulos
wrote:
>
> Hi Michael,
>
> That works perfect thank you!!!
>
> Cheers,
> Christos
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offi
Thanks Vabz but I don't want just a function that replaces any value. My
post explains fully what I needed!
Cheers
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexce
>
> In fact I used a slightly different code... It finds a row with a certain
> value (the risk id for my case) and replace another value in the same row
> that I set. I hope I this code helps others as well! Thank you again for
> all your help and feedback!!!
>
Sorry for the comments but I t
Christos, you could have achieved this by following simple line too:
Sub Macro1()
Prompt = "What is the original value you want to replace?"
Title = "Search Value Input"
Search = InputBox(Prompt, Title)
Prompt = "What is the replacement value?"
Title = "Search Value Input"
Replacement = InputBox(P
Hi Michael,
That works perfect thank you!!!
Cheers,
Christos
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread ti
Hi Christos,
Try this code...
Sub Button1_Click()
Dim WS As Worksheet
Dim Search As String
Dim Replacement As String
Dim Prompt As String
Dim Title As String
Dim ID As String
Dim mu As String
Dim temp As Long
Dim R As Long
Dim C As Long
Dim MatchCase As Boolean
Prompt = "What is the risk ID?"
Ti
Thank you very much, Paul. When I received the file, it was quickly
obvious that this other party had introduced an error into the file that
was producing a bunch of #0's and such and that the goal seek would never
be able to find a solution. I guess these VBA error messages are just too
gene
Hi,
Got the solution for this problem I have declared variable to integer then
I changed it to Long. Now macro is working fine.
Thanks,
Chandra
On Wed, Aug 14, 2013 at 10:25 AM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> Instead of sharing Screen shot it would be nice if you can s
Instead of sharing Screen shot it would be nice if you can share file
On Tuesday, 13 August 2013 20:01:06 UTC+5:30, Chandru wrote:
>
> Hi,
>
> While running macro am getting run time error 6 as shown in the attached
> file. I am using huge data which contains 9 rows.
>
> Could you please
Hello,
Give more details.
At what stage, you are getting the error.
When opening the file,
When opening a particular form/ running a query / executing a report etc.
Also provide The size of access file.
Once thing you can try is to condense the access database using compact &
repair database
ActiveCell.Rows("1:" & nrow).EntireRow.Select
On Jun 15, 4:11 pm, Hiren Sheth wrote:
> Hi
>
> I am getting following error while running below mention code.
>
> Please help.
>
> [cid:image001@01CC2B7B.1B6C0EA0]
>
> Dim nrow As Long
> ActiveCell.Select
> Cells(8, 1).Select
> ActiveCell.Offs
Getting rid of the .text and ,value cleared up the run error. However,
the activate didn't work as expected. It started writing in the input
table which is what I was trying to avoid in the first place. Is this
an excel vs vba command issue? What is the easiest way to get the
activate to switch.
Please check the following Microsoft solution. May be helpful for you.
http://support.microsoft.com/kb/305995
Regards,
Mudassar Ramzan
- Original Message -
From: Fabio Lemos
To: excel-macros@googlegroups.com
Sent: Tuesday, May 19, 2009 5:33 PM
Subject: $$Excel-Macros$$ Re
It could be the access registry lock in access. You should use a less
conservative lock.
Fabio L. Lemos
Em 19/05/2009, às 08:30, Alokeshwar Tiwary
escreveu:
> Hi All,
>
> Does anyone know why this error occurs? I am using DAO in a Excel
> Userform to save data in MS Access. Approx 40 use
Hi Shrinivas,
Mr. Powell has rightly said, please debug the same way.
And If it helps please also check, if you have larger amount of
columns or rows than your friend, since this also cause "Subscript Out
of Range". Run on lesser or same amount of rows , also ensure correct
sheet/file names in th
Shrinivas --
My guess is that the Excel sheet you are trying to reference is either
misnamed or does not exist
When the error appears, click the Debug button -- this will take you
to the offending line of code in the VB Editor
This will enable you do identify the cause of the error
Hope it he
x27;t know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: Mudassar Ramzan
To: excel-macros@googlegroups.com
Sent: Monday, 9 February, 2009 6:48:54 PM
Subject: $$Excel-Macros$$ Re: Run-time error
So why you don't want to share with group mates???
- Original Message -
From: Alokeshwar Tiwary
To: excel-macros@googlegroups.com
Sent: Monday, February 09, 2009 2:46 PM
Subject: $$Excel-Macros$$ Re: Run-time error '-2147352571 (80020005) - Type
Mismatch
Kin
Kindly ignore the request.. I figured it out myself..
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don'
25 matches
Mail list logo