# Posts by cs2007

• ## Click cells keep them highlighted

Re: Click cells keep them highlighted

I already tried that but not solved the problem.

Quote from cytop;653391

Try zooming your worksheet to anything other than 100%, then back to normal. Does it clear...?

• ## Click cells keep them highlighted

Re: Click cells keep them highlighted

Hi pike and thanks for the prompt reply.

The CTRL key is not stuck. All the clicked cells keep the border and look as active cell. For further information please see the attached screenshot.

• ## Click cells keep them highlighted

Hi,

I am using window 7 with excel 2010 and when click a cell it highlight the cell and when click another cell it keep highlight for the previous clicked cells too. it is not the case and issue with F8 key.

• ## Number Of Days Between Julian Day & Current Dates

Re: Number Of Days Between Julian Day &amp; Current Dates

Yeat it is working ...

• ## Number Of Days Between Julian Day & Current Dates

Re: Number Of Days Between Julian Day &amp; Current Dates

But I dont like to use the claculator, I want to know the concept, and how to obtain the JD of a specific date.

Suppose someone ask me, what is the JD in '1982/01/01'

P.S:
The Julian day or Julian day number (JDN) is the integer number of days that have elapsed since the initial epoch defined as noon Universal Time (UT) Monday, January 1, 4713 BC in the proleptic Julian calendar.[1] That noon-to-noon day is counted as Julian day 0. Thus the multiples of 7 are Mondays. Negative values can also be used, although those predate all recorded history.

Now at 16:25, Thursday May 15, 2008 (UTC) the JDN is 2454603. The remainder of this value divided by 7 is 4, an integer expression for the day of the week with 0 representing Monday.

• ## Number Of Days Between Julian Day & Current Dates

Hello everybody,

As I searched I see that JD "Julian Day" started from '4713/01/01' BC, counted 1 noon at noon.

and suppose we are now in '2008/05/16', what is the algorithm of finding the days from '4713/01/01' BC through '2008/05/16'?

if it is with detail, very nice of you...

• ## Color Selected Row

Re: Color Selected Row

Thanks Mr. StephenR, Exactly what I wanted...

Ok Mr. Dave...Thanks

Thanks Mr. shg too...

• ## Color Selected Row

Hi,
I need to color the row which I am, and whenever the selection has changed, then color that row...How it is possible?

• ## Convert Solar Date To Gregorian Date

Re: Convert Solar Date To Gregorian Date

Thanks again...

• ## Convert Solar Date To Gregorian Date

Re: Convert Solar Date To Gregorian Date

Thanks Mr. Shg,
I exactly need the Julian to Civil "JDN2Civil()" function directly take the parameter of the Persian "1386,9,10"...

How that is possible?

• ## Convert Solar Date To Gregorian Date

Hi,
How can I create a UDF which convert the Solar Date "1386/9/10" to Georgian Date "2007/12/01". thnx

• ## Hide Range Names

Re: Hide Range Names

Thnx very much

• ## Hide Range Names

Hi,
Suppose I have ten Names in Excel, and I dont like any one see them, How can I hide them (Names not cells)?

• ## Advaced Filter ListBox Via User Form

Re: Advaced Filter ListBox Via User Form

Dave Hawley, Thanks much...

I will amend that on my own problem, then will post again

• ## Display Related Data For Chosen Item

Re: Display Related Data For Chosen Item

Thanks very much, it is working well.

But instead "SelectionChange", is it possible to show hyperlink on column A, those rows which has "Code" not blank, when another student info added then the hyperlink show on the code of that student too?[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Bump[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Bump

• ## Display Related Data For Chosen Item

Re: Hyperlink Pass The Data To Another Sheet

Quote from Dave Hawley

You are making it a lot harder than it needs to be. Simply create a PivotTable and drop the "Code" field into the Page Field.

Then you can filter down by "code" and/or use the Show Pages... feature of the PivotTable to create x new Sheets with only that persons details on.

Thanks for the info, but here they asked to do something like this[hr]*[/hr] Auto Merged Post;[dl]*[/dl]

Quote from Bill Rockenbach

Assuming your sudent ID is in column A (or any column you want to use) put this code in the data sheet module. When you select the students ID it will copy the students data as defined in your code.

Code
``````Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Columns(1)) Is Nothing Then

'code to copy target data to report sheet

End If
End Sub``````

May I request you, how the data can be copied to the desired sheets and columns, because I dont much vba in excel

• ## Display Related Data For Chosen Item

I have the student information on a sheet, also I have another sheet named "Report", then I like that hyperlink appears on the "student code", and when click any code of the student, his/her data shown in other sheet "Report".

How can I do that?

• ## Advaced Filter ListBox Via User Form

hello everybody,
I have 7 columns with many records, now I want to have Advanced through userform, means there according to my criteria all the data should be filtered on the sheet and on the form on a list box, and when I click on the any record on the list box, then the information of that record shown on another sheet "Report"...

How it is possible?

• ## Put Chosen Picture In Comment & Retrieve Picture On Other Sheet

Re: Put Chosen Picture In Comment &amp; Retrieve Picture On Other Sheet

Yeah for sure, I appreciate if you do it through button click (coding)...Thanks

[No questions not fitting under your choice of thread title allowed][hr]*[/hr] Auto Merged Post;[dl]*[/dl]I got new idea, and wanted to share it...
If instead of putting picture in comment, just we store the name of the picture in cell, and by "FileCopy" method we copy the picture to a specific folder where our workbook is located, and then we use "Image" control on the sheet, and get the path of the workbook, concatenate with the folder, and then concatenate the name of the picture which is located in the cell...and use it as parameter of "LoadPicture" function...[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Got new idea!!!
If instead of storing picture in comment, we just store the picture name in the cell "Photo", and then via "FileCopy" method we copy the picture into a specific folder where our workbook is located, then for retrieving, we put an "Image" control on Report sheet, then we get the path of the workbook, concatenate with the foldername, concatenate with the picture name which is in cell, and pass this as parameter of the "LoadPicture" function...

• ## Put Chosen Picture In Comment & Retrieve Picture On Other Sheet

Re: Put Chosen Picture In Comment &amp; Retrieve Picture On Other Sheet

Thnx for the code,
Can any one guide me, how to retreive the picture which is in comment, on other sheet "Search", through VLOOKUP formula?