# Search:

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

Page 1 of 6 1

## Search: Search took 0.06 seconds.

by ipbr21054
Replies
1
Views
64

### Re: Could you check my code please.

Hi,
Still trying to get this right,

I have changed the middle part to the below.

If CDate(strDate) > CDate("05/04/2019") Then
sh.Cells(fRow, 4).Resize(, 2).Value =...

by ipbr21054
Replies
1
Views
64

### Could you check my code please.

This is the whole code from my worksheet,

When i click the Transfer button it should copy & paste like shown below.

Copy G INCOME cell D31 & paste to G SUMMARY cell D9

Copy G INCOME cell...
3. ## Thread: Expand on current code in use

by ipbr21054
Replies
4
Views
77

### Re: Expand on current code in use

Works a treat thanks DanteAmor

by ipbr21054
Replies
4
Views
71

### Re: Calculation just doesnt add up

I knew that but been a long day BODMAS

Thanks

by ipbr21054
Replies
4
Views
71

### Calculation just doesnt add up

Hi,
I am trying to write a small basic code for fuel allowance of 45p per mile.

Currently i use this which works fine & correct.

=E18*0.45

But i now wish to add the cell value at E34
6. ## Thread: Expand on current code in use

by ipbr21054
Replies
4
Views
77

### Expand on current code in use

Hi,

Supplied is the current code in use.
I wish to expand the code to apply a number in the corresponding cell in column E
Target cells are currently in column D "name of shop" & now wish to...
7. ## Thread: VLOOKUP based on drop down list

by ipbr21054
Replies
4
Views
121

### Re: VLOOKUP based on drop down list

Hi,
This gives me a blank cell but is it correct & ok to use ?

=IFERROR(VLOOKUP(B5,\$N\$4:\$Q\$21,2,0),"")
8. ## Thread: VLOOKUP based on drop down list

by ipbr21054
Replies
4
Views
121

### Re: VLOOKUP based on drop down list

Hi,
Yes that works.

Before i select from the drop down list colmns C,D & E show #N/A until i make a drop down selection.
Need to be able to show the cell is blank without the #N/A

Im not sure...
9. ## Thread: VLOOKUP based on drop down list

by ipbr21054
Replies
4
Views
121

### VLOOKUP based on drop down list

Hi,
I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is.
Here is the info for you.
...
10. ## Thread: Code lags when run

by ipbr21054
Replies
6
Views
98

### Re: Code lags when run

Hi,

Anybody have a few minutes spare to check this workbook or see if they can replicate my lag issue.
Its a very small workbook but i seem to have the issue on the worksheet called G INCOME
...
11. ## Thread: Macro button on desktop

by ipbr21054
Replies
2
Views
72

### Macro button on desktop

Is it possible to have a button on the desktop which would open a msgbox & then two options.

Selecting one option to open this workbook selecting the other option would open a different workbook.
12. ## Thread: Code lags when run

by ipbr21054
Replies
6
Views
98

### Re: Code lags when run

Hi,
Yes i do.
There are other worksheets in this workbook with code etc.

What i have just done for the last hour etc is to move say 5 worksheets from this workbook & have them in there own...
13. ## Thread: Code lags when run

by ipbr21054
Replies
6
Views
98

### Re: Code lags when run

Hi,
Just above my pc clock whilst i am waiting for excel to do its job i see some text flashing like,
Calculating 2 processors ?
14. ## Thread: Code lags when run

by ipbr21054
Replies
6
Views
98

### Code lags when run

Hi,
On my worksheet called G EXPENSES i have the following code in use but when i leave the cell i dont see the name appear straight away but more like 2 seconds later.

Private Sub...
15. ## Thread: Merge two Worksheet_Change codes

by ipbr21054
Replies
7
Views
123

### Re: Merge two Worksheet_Change codes

No problem i started like that.
Thanks the code works & welcome to the forum
16. ## Thread: Merge two Worksheet_Change codes

by ipbr21054
Replies
7
Views
123

### Re: Merge two Worksheet_Change codes

Ok,
I will check.

On a side not when you put code here you need to put it in between tags.
Look on the toolbar where you type your message and you will see this logo #

Click on it and you...
17. ## Thread: Merge two Worksheet_Change codes

by ipbr21054
Replies
7
Views
123

### Re: Merge two Worksheet_Change codes

Hi,
Where did the range A1:B20 come from ?
18. ## Thread: Merge two Worksheet_Change codes

by ipbr21054
Replies
7
Views
123

### Merge two Worksheet_Change codes

Hi,
I habe these two codes.

Private Sub Worksheet_Change(ByVal Target As Range)If Intersect(Target, Range("J1:M3")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value =...

by ipbr21054
Replies
2
Views
58

Morning,
So looking at the sheet this was taken from columns 1 & 7 are dates where all the other columns are text.

Thanks

by ipbr21054
Replies
2
Views
58

Morning,
I see this code a few times on my worksheets but dont know what its actually doing,please can you advise.

Private Sub Worksheet_Change(ByVal Target As Range) With Target
If...
21. ## Thread: Search column & place names in list box

by ipbr21054
Replies
10
Views
179

### Re: Search column & place names in list box

I didnt even try that piece of code.
works great,many thanks friend
22. ## Thread: Search column & place names in list box

by ipbr21054
Replies
10
Views
179

### Re: Search column & place names in list box

Many thanks,thats sorted A-Z great.

Last thing.
Im trying to close the userform after i made a selection in the listbox.
Currently i type my known info in the textbox & see the results appear in...
23. ## Thread: Search column & place names in list box

by ipbr21054
Replies
10
Views
179

### Re: Search column & place names in list box

Thanks,
Ive now done it correctly & works nice.

Can i ask a couple of questions please that relate to the workings of it.

In the TextBox1_Change code ive added the following.

TextBox1 =...
24. ## Thread: ComboBox drop down where list should be Surname then First name

by ipbr21054
Replies
8
Views
239

### Re: ComboBox drop down where list should be Surname then First name

You are correct as i couldnt get it to work / flow smootly.
I wouldnt say cross post as not in the same group and was looking for a fresh pair of eyes etc to help.

I am awaiting on Dante to...

by ipbr21054
Replies
10
Views
179

@DanteAmor