Search:

Type: Posts; User: Trebor76; Keyword(s):

Page 1 of 6 1

1. Thread: Copy and paste from hidden sheet

by Trebor76
Replies
13
Views
370

Re: Copy and paste from hidden sheet

Thanks for letting us know and you're welcome :)
2. Thread: Copy and paste from hidden sheet

by Trebor76
Replies
13
Views
370

Re: Copy and paste from hidden sheet

Hi dwool40,

Maybe this:

Option Explicit
Sub Macro1()

3. Thread: Code to change caption of labels

by Trebor76
Replies
3
Views
130

Re: Code to change caption of labels

Thanks for letting us know and you're welcome :)
4. Thread: If Sheet 1 Match Sheet 2

by Trebor76
Replies
8
Views
94

Re: If Sheet 1 Match Sheet 2

The formula will show the results for the first match. If there are multiple matches I think you'll need an array formula but I'm no expert as those :( though I'm sure someone on this forum will be...
5. Thread: If Sheet 1 Match Sheet 2

by Trebor76
Replies
8
Views
94

Re: If Sheet 1 Match Sheet 2

Strange, it worked for me :confused: I don't give out my email address I'm afraid.

When you say it doesn't work - what happened? If #N/A was returned that's because an exact match wasn't found.
6. Thread: If Sheet 1 Match Sheet 2

by Trebor76
Replies
8
Views
94

Re: If Sheet 1 Match Sheet 2

Hi nitesh2009,

Welcome to MrExcel!!

If I've understood correctly, (big If here) this formula in cell B2 of Sheet1 should do the job:

=INDEX(Sheet2!A:A,MATCH(C2,Sheet2!B:B,0))

Regards,

by Trebor76
Replies
4
Views
139

Re: 2 Worksheets and Yes answer

Hi sh3rvin,

Put the following in cell R2 (assuming this is the starting Row - change the following to suit) and copy down as far as required:

=VLOOKUP(A2,Sheet1!A:O,15,FALSE)

Regards,
...

by Trebor76
Replies
17
Views
456

Re: Compile error

To use this proposed early binding method, you need to select the Microsoft Scripting Runtime option (Tools > References).

I would actually use late binding like so:

Dim fso As Object, folder...
9. Thread: Control Userform labels and buttons with VB macro

by Trebor76
Replies
19
Views
384

Re: Control Userform labels and buttons with VB macro

Try this as the forms' Initialize event code (currently the last code on the form):

Private Sub UserForm_Initialize()

Dim lngCounter2 As Long
Dim MyLabel As String

For...
10. Thread: VBA to insert text

by Trebor76
Replies
6
Views
220

Re: VBA to insert text

You're welcome :)
11. Thread: Control Userform labels and buttons with VB macro

by Trebor76
Replies
19
Views
384

Re: Control Userform labels and buttons with VB macro

The best thing would be to use a hosting site like www.box.com or www.dropbox.com and post your workbook there (devoid of any sensitive data) so we can see what's happening.
12. Thread: VBA to insert text

by Trebor76
Replies
6
Views
220

Re: VBA to insert text

Hi Russk68,

As an example, the following will work for cells A1, A3 and the range B5:B10

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target,...
13. Thread: Code to change caption of labels

by Trebor76
Replies
3
Views
130

Re: Code to change caption of labels

Hi Bandito1,

You need to store the value in a cell that can be referred to - I have used cell A1 of Sheet1 in the following example (change to suit):

Option Explicit
Private Sub...
14. Thread: Control Userform labels and buttons with VB macro

by Trebor76
Replies
19
Views
384

Re: Control Userform labels and buttons with VB macro

So to hide the label controls you just needed to change the control from "TextBox" to "Label" from my solution for you here like so (you could have even put it in the form's Activate event along my...
15. Thread: Assign a Userform to a control button on a worksheet

by Trebor76
Replies
9
Views
306

Re: Assign a Userform to a control button on a worksheet

Hi Rod,

It's very hard to know what's gone wrong without seeing your workbook but at a guess I'd say the form name has changed from "AdjustResetButtonForm". Double check the form it is spelt...
16. Thread: Control Userform labels and buttons with VB macro

by Trebor76
Replies
19
Views
384

Re: Control Userform labels and buttons with VB macro

Hi Rod,

The visible property is a boolean variable meaning it has to be set as VB True (value of 1) or VB False (value of 0) not a string like you have i.e. "False" and "True".

Remove the...
17. Thread: Assign a Userform to a control button on a worksheet

by Trebor76
Replies
9
Views
306

Re: Assign a Userform to a control button on a worksheet

It was just me so thank you and you're welcome :)
18. Thread: Summing the bottoms of two columns

by Trebor76
Replies
2
Views
97

Re: Summing the bottoms of two columns

Hi cguy3000,

Try this:

Option Explicit
Sub Macro1()

Dim lngLastRow As Long
19. Thread: Data from userform to cells

by Trebor76
Replies
1
Views
80

Re: Data from userform to cells

Hi cvanderweide92177,

Welcome to MrExcel!!

A couple of things - you're setting the n variable based on the last row in Col. A yet you are posting to columns K to N. As such I have written the...
20. Thread: VBA: Filter dataset based on listed values column A Sheet2

by Trebor76
Replies
8
Views
446

Re: VBA: Filter dataset based on listed values column A Sheet2

That's a shame. Thanks anyway.
21. Thread: VBA: Filter dataset based on listed values column A Sheet2

by Trebor76
Replies
8
Views
446

Re: VBA: Filter dataset based on listed values column A Sheet2

Hi Fluff,

Can I ask you a question - what's the syntax for filtering the data set where the items do not agree to what's in the array i.e. what's wrong with this...

.AutoFilter Field:=1,...
22. Thread: Assign a Userform to a control button on a worksheet

by Trebor76
Replies
9
Views
306

Re: Assign a Userform to a control button on a worksheet

This code needs to be part of the form not put a standard module.

Copy the code, right-click on the form in the Visual Basic Editor (VBE) click View Code and paste the code in that module.
23. Thread: Need Custom Function to Format Cell Values

by Trebor76
Replies
5
Views
261

Re: Need Custom Function to Format Cell Values

That's great. Thanks for letting us know :)
24. Thread: Assign a Userform to a control button on a worksheet

by Trebor76
Replies
9
Views
306

Re: Assign a Userform to a control button on a worksheet

Hi Rod,

I'm not sure as I tested my code and it worked fine :confused:

What code is causing the issue?

Robert
25. Thread: Need Custom Function to Format Cell Values

by Trebor76
Replies
5
Views
261

Re: Need Custom Function to Format Cell Values

Hi Alex20850,

This will put the apostrophe around the entry if the text is V or D or else it won't (hopefully this is what you need):
...
Results 1 to 25 of 150
Page 1 of 6 1