eantime how can I open the file with the Workbook_Open macro
disabled so I can correct the code...or at lease remove it.
I am using MS Excel 2013
Thank you,
Rob
--
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 o
anticipate getting this request for
several similar projects and I want to simplify the process.
I appreciate any direction you can provide.
Thank you,
Rob
--
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
ssors)' .
It is not a big deal I am curious why it calculates when there are no
formulas, links, macros or anything else that would cause this.
Is there a way to shut this 'calculation' off?
Thank you,
Rob
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Vabz...Thank you very much for the explanation and fix...it works...
Rob
On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote:
> hi
>
> You will get error if no value is added in list box.
>
> add line "on error resume next" in beginning to avoi
On a worksheet I have two listboxes; ListBox1 and ListBox3. Dependant upon
what is selected in ListBox1...it will automatically enter the appropriate
range into the ListFillRange of ListBox3:
Private Sub ListBox1_Click()
With ListBox3
.ListFillRange = Sheets(2).Range("T30")
.S
My application allows the user to make a copy of a worksheet so it can be
viewed outside of the application. The problem I have with this is the
code written to that specific worksheet.
Is there code I can include in the 'make copy' macro that would remove all
VB code associated to that sheet
For whatever reasons the size of my ActiveX ListBox expands and shrinks on
an inconsistent basis forcing me to use the Forms ListBox instead.
The problem I have with the Forms ListBox is the small font.
1. Is there any way to change the font size within the Forms - ListBox?
2. If not, is the
I am trying to determine the code that would (passively) record the users,
within our company, who are using a selected workbook.
Is this feasible and if so how do I write it.
Thank you,
Rob
--
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
DP,
Sorry I didn't respond soonerthank you for you direction...much
appreciated
Rob
On Thu, Feb 20, 2014 at 6:11 PM, De Premor wrote:
> Hi Rob,
>
> Try this 2 code, first sub code just need a few line code, but it slower
> than next sub code, i suggest second sub code
Ricardo,
Thank you very much, I really appreciate your help.
Rob
On Fri, Jan 24, 2014 at 7:15 PM, Ricardo® wrote:
> Hi Rob,
> To solve the problem of error, you can delete this (
> Sheets("List3").Select ), it will not affect the main macro.
>
> Basole
>
sage?
Thank you for your help with this.
Rob
On Thu, Jan 23, 2014 at 2:21 AM, Anoop K Sharma wrote:
> Hi Rob,
>
> Please have look at attached one...
>
>
> On Thu, Jan 23, 2014 at 6:48 AM, Rob Flott wrote:
>
>>
>>
>> On Wednesday, January 22, 2014 3:36:1
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in one example is A3
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in one example is A3
Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
names. This range will vary, and I have a Named Cell that identifies the
range. For example the range of names in one example is A3:A8. But in
another example that range could be A3: A21. I would like the ListBox to
l
ell !
> Any chance you could use Record Macro
> to autogenerate some code to analyse for clues?
> Also keep an eye on datatypes.
>
> Clivey,London.
>
> On Jan 30, 9:15 pm, Rob wrote:
>
> > Can anyone help please?
>
> > I have tried to apply the following VBA c
Can anyone help please?
I have tried to apply the following VBA code in order to establish a
validation within a particular cell that will measure the data entry
against date values in other cells:
With Selection.Validation
.Delete
.Add Type:=xlValidateCustom, AlertStyle:=
Daniel,
Thank you for the suggestion, but I am not sure where the file is that
you are suggesting I look at.
I have the following code, but it does not seem to work:
Set Source = Range(Cells(3, 10), Cells((LastRow + 1), LastColumn))
X = 1
Y = 1
ReDim Data(Source.Count)
LastColumn = Acti
I have a macro that loops through a range of cells. It takes the text
in the cell, determines the appropriate validation group (a range of
cells on another spreadsheet) and compares it to that range. If it
finds the value, it changes the color to blue, if it doesn't find the
value in the list, t
delays.
Robby
On Jan 4, 1:58 am, Dave Bonallack wrote:
> Hi Rob,
> This problem is better solved with conditional formatting.
> Select all the valid ICD9 codes on the second sheet, and name the range -
> let's say, List
> Then on 1st sheet, select all the cells you want to
t of range.
Right now its set for only column W. I don't know how to set this to
the active column.
Any help would be appreciated.
Thanks.
Rob Buonocore
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
t of range. Right
now its set for only column W. I don't know how to set this to the
active column.
Any help would be appreciated.
Thanks.
Rob Buonocore
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
21 matches
Mail list logo