Search:

Hi,

I have another question on spin button. The date function doesn't seem to work in the spinbutton code as an error pops out saying "can't find project or library".
For example, i have a...

Hi,

Thanks, i managed to modify my code

Private Sub SpinButton1_Change()

Dim FstDate, ExpDate As Date
Dim DayNo, Link_Cell As Integer
Dim ExpCell As Range

Hi,

Many thanks for your guidance, i managed to write the code that almost return a result that i wanted.
I have 2 issues that i couldn't figure out the solution. Here is the code:

Private...

Hi,

I am trying to draw a spin button on a userform, in order to generate the date of the 3rd friday of each month that is after the current date (today). In order words, the coming 3rd friday...

Hi

Many thanks

xwxc

Hi,

I'm trying to input a formula into a particular cell, of which the formula involves a pre-defined variable, as below:

Range("C" & Rw).formula = "= Range("A" & Rw) * Range("B" & Rw) *100"
...

Many thanks

xwxc

Hi, many thanks, the code works perfectly.

Do you mind to explain to me why the additional of #1 next to "target" makes such a different? I tried to do a search but couldn't be satisfied.
...

Hi,

thanks for the amended code.

I meant to put the worksheet_change code into the active worksheet, not the 'this workbook'.

When i change the cell value in C5:C31 to 'sent', the code...

Hi,

I am setting up a worksheet that contains some vba functions and among them, I wrote a code with Worksheet_change in order to call up a userform if the cell value in the target changes to...

Hi.

Thank you very much, that's exactly what i have been trying to achieve.
Many many thanks

Best,

xwxc:)

:(...

Sorry i got another question on your code...

How should i include your code as part of mine, where i have a commandbutton that contains the code as below:


Private Sub...

Hi,

I am going to insert as many as 27 checkboxes to a column, with 1 in each row.
Is there a simple way to do it at 1 go?
Is the checkbox from Control toolbar much useful than the on from Form...

Yeah...something like this, but instead of writing code of 'GetRowFromChkBox(WatchList_ChkBox1)' separately for each checkbox, is there any alternative by doing them at 1 time? Would the checkbox...

To Clarify what i'm going to do,

I'd like to have a code to copy info from column L to column U, if the checkbox is ticked.

Regarding the checkboxes, they were input in tough way--one by one,...

Hi,

Sorry i should have done it earlier
thank you again

xwxc

Hi, that's great, thank you for the code.

Also, with the same worksheet, i've been trying to write the code to copy the certain cells on the row where the checkbox is true (note only 1 'true' can...

Hi,

I managed to upload the pdf format.
Please see attached

thank you again

xwxc

Hi Thanks for your reply.

I was trying to upload the file but for some reason it was unsuccessful as it said "invalid file".

A B C D E
1 FALSE
2 FALSE
3 TRUE √
4 TRUE √ ...

Hi,

I just started to learn how to write vba code for excel and i encounter an issue with 'count' which i couldn't get much information from the internet. It'd be great if you could help me with...