Mayday MaydayI need help
My workbook contains several sheets displaying various report forms. The
content of each report is based on the selections made from a UserForm.
On the Workbook_Open macro I have 'Call OpenUF1' code to open the UserForm.
Sub OpenUF1()
Load UserForm1
UserFo
I have a workbook with nearly 200 worksheets. Each worksheet is named for
a specific retailer.
Included in this workbook is a sheet listing 75 of these retailers.
I want to create the VB code that opens the sheet with the list of 75
retailers, selects the name and then finds the corresponding s
Why does my sheet tab calculate if there are no formulas on the tab, or
even on the workbook?
I am using Excel 2010 and my workbook has 3 tabs; each with about 3400 rows
and about 30 columns of data.
Every time I sort the data, down in the status bar it shows 'Calculating
(4 Processors)' .
d this error..
>
> cheers
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott > wrote:
>>
>> On a worksheet I have two listboxes; ListBox1 and ListBox3. Dependant
>> upon what is selected
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) !
; Result(k, 1) = Data(j - 1, 2)
> k = k + 1
> Next
> End If
> Next
> Sheet3.Range("A5").Resize(k, 2) = Result
> End Sub
>
>
> Rgds,
> [dp]
>
>
> On 21-02-2014 5:10, Rob Flott wrote:
>
>
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
14 matches
Mail list logo
