Blogs

Increase font size of links

I would like to increase the font size of the links that populate my index sheet in excel but don't know what the code is or where to put the code. I have tried a few things but none work. Here is my code:

Option Explicit

Private Sub Worksheet_Activate()
Dim wSheet As Worksheet
Dim l As Long

l = 1

Me.Columns(1).ClearContents

With Me.Cells(1, 1)
.Value = "INDEX"
.Name = "Index"
.Font.Bold = True
.Font.Name = "Arial Black"
.Font.Size = 18
End With

MACROS (HELP)

Sir,

I am very much interested to learn a Macros & VBA in Excel kindly advice to best institutes in Hyderabad city.

VINOD

DATA VALIDATION (HELP)

Sir,

i am entering data which contains A1 Chq no. and B1 amount i am entering one by one chq no and amount.

Now i need to not allow same chq no. in A1 column i am trying to use data validation (customs, countif formula).

kindly advice.

VINOD

VLOOKUP (HELP)

Sir,

i have data contains 1000 Chq no. i.e, A1 to A1000 (double chq no's) and amounts in B1 to B1000

Now i need to pickup same chq no. to same amount ie.,

chq no. amount

12345 1000000
12345 3000000

i am using Vlookup formula but my vlookup is pickuping only first value in B1 how to pickup second value through using vlookup.

kindly advice.

VINOD

VBA Formula Help

I would like to track the streaming value in C11 when it is greater than the maximum starting value of E11 "5000"

I need to pasted special values in cells "F11:F-500" tracking each occurrence and value for each time C11 exceeds 5000
Anyone good at writing VBA the file is attached that explains what I am trying to achieve.
Thanks for reading

CHEQUES MAPPING IN XL

Sir / Madam's

I have data which contains cheques numbers and amounts from A1 to A41000 and B1 to B41000 (doubled).

now i have to map the same chq no. and same amounts i.e., EX:

chqno. amount

335664 1,00,000
335664 1,00,000
335664 1,00,000

110001 2,00,000
110001 2,00,000
110001 2,00,000

how do i do this. Kindly advice sir / Madam

VINOD

Reply to forum topic "Automate a keying in Job"

This is a reply to forum topic "Automate a keying in Job":

excelexperts.com/automate-keying-job

 

Download an example file to see the solution.

Vishesh's picture

Extract Data from Web (URL)

Here is a small piece of code to extract data from a web page.

Extracting Coefficients From A Trend Formula

Can anyone please tell me an easy way to transfer or copy the coefficients of a polynomial equation, say 2nd degree, generated by adding a trend line to an "x-y" scatter chart into cells so they can be used to generate other "y" values using the equation. Thanks.

refresh data in power pivot automatically without the use of share point

can anybody tell me how to refresh data in power pivot automatically without the use of share point

how to crack password of excel

1) Can anybody tell me that how can we crack password of vba in excel.

2) Can anybody tell me how to unprotect sheet, even though i have lost my password.

Nick's picture

Excel Experts XLA

Hi all

We are writing an XLA for Excel VBA developers... Please let me know if you can recommend something to be added.

Nick

How to open excel file with .xlsb extension in our android mobile or tab.

Dear Friends.

Can anybody tell me that how can we open an excel file with .xlsb extension in our android mobile and tablet.

I downloaded some softwares but couldn't open .xlsb file.
Can anybody help me out with solution.

mohan.pandey87's picture

Add new value field in a pivot table using excel vba.

Some time we need to add a formula or value field in an existing pivot table.

Reply to forum topic "How to filter some data and copy some cells"

This is a reply to forum topic "How to filter some data and copy some cells":

excelexperts.com/how-filter-some-data-and-copy-some-cells

 

Excel CONCATENATE

I applied this formula =CONCATENATE(A1"-"B1) to a spread sheet of mine and now I need to get rid of the cells that were merged from. How do I do this with out loosing the new data in the merged cell???

mohan.pandey87's picture

Get system’s date and time separator

Here is how to check what is the separator of date and time using excel vba

application.International(xldateseparator)
application.International(xltimeseparator)

Colour my Cells

In my worksheet I have a Drop down box in D23 with 3 options say 1,2 & 4 plus blanck
what I am seeking to do is that when I select either 1, 2 3 or blank that d10 changes colour - say green for 1 - blue for 2 and yellow for 3 with white for Blank

I have the code to make this happen as indicated above - but I want to extend this for rows - D23 to d28 for the Drop downs and rows d10 to d15 for the colours

I just cannot seem to be able to add to the esisting code to make this happen

Help appreciated

data type of textbox in excel

1) How can we set data type of text box to number in excel so that it always accepts number only and if user inputs character then it'll not accept it.

2) How can we set not null to a text box so that textbox would become mandetory..

Need comparison of two excel files macro

Hi Any body help me to write a code for comparing two excel files and get result next sheet or new anything will be ok.

Please guide me what is best possible way to get result

Note :
One is Old revision another latest revision please compare with older version and give me what is new in latest revision

Extract notes section from ppt

Greeting,
So i have to write an excel macro extracting filename, time &date stamp, and notes from powerpoint. the notes are supposed to be copied exactly as how they look in the notes section of the powerpoint. So i came up with this, i just need help copying the notes, can someone help me plz

Sub PptToExcel()
Dim Ops As Object
Dim PPApp As Object
Dim PPPres As Object
Dim Shp As Object

Range("A1").Value = "File Name"
Range("B1").Value = "Date and Time"
Range("C1").Value = "Notes"

Dim FileName As String
Dim File As String

Range("A5:A2000").ClearContents

Vishesh's picture

Solve Linear Equation

Here is a small VBA code to get the result of an equation which have one variable.

Reply to kumarshivamgupta's blog questions

This is a reply to the following blog topics:

 - Scroll bar within excel sheet:

excelexperts.com/scroll-bar-within-excel-sheet

 - Insert sheet within sheet:

excelexperts.com/insert-sheet-within-sheet

 - Freeze shapes in excel:

excelexperts.com/freeze-shapes-excel

 

Hello, Shivam,

Freeze shapes in excel

Is there any way to freeze a shape in certain place.

That means,when we make a shape(rectangle) in our excel sheet and then when we scroll up/down or left/right sheet moves accordingly but shape will not move.
It will retain the same place.

Please check for new sheet.

Reply to forum topic "Changed Cell to Userform to Write Another Cell"

This is a reply to forum topic "Changed Cell to Userform to Write Another Cell":

excelexperts.com/changed-cell-userform-write-another-cell

 

Hello, joedirty,

I do modifications onto your example file and attach it here. If you have a questions - ask me.

 

Best regards.

insert sheet within sheet

How can we add sheet within sheet.

For eg: If I am having sheet1 in my workbook and now I want to show another sheet within sheet1, then how can we do this.

scroll bar within excel sheet

How can we make scroll bar (horizontal and vertical )within excel sheet so that we can restrict an area where data can be shown.

Here I am attaching a file through which we all can get as an idea , what exactly I want.

As in this sheet1 red border is showing area for total data.
Green Border is showing the area within which we want to show data of this pivot table.
This means that there should be scroll bar after green border
So how should I do this.

Reply to forum and blog topics "Regarding click event of charts"

This is a reply to forum and blog topics "Regarding click event of charts", which can be seen here:

excelexperts.com/regarding-click-event-charts

excelexperts.com/regarding-click-event-charts-0

 

Hello, Shivam,

Regarding click event of charts

I am attaching a file which contains two sheets named as metadata and report.
I have made two charts on it , now when I select any region on graph1 then customers related to that particular region must be shown in graph2.

I want to use region graph for filtration process.

santosh1184's picture

Required Rectification in VBA code ?

Dear VBA Experts,

Attached VBA script is being used by me to import images and their information in PPT from a folder, currently its importing one image per slide with related information in PPT.

In the text file from where data (products information's)is being fetched in ppt I have only one path for each product, here i need to import two images per slide for each product. The second images path I can put in the next column of the existing path.

Size dimension for both the images will be different, kindly make the rectification in the attached VBA script as per my requirement.

Syndicate content