ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I set the title permenantly (https://www.excelbanter.com/excel-programming/300708-how-can-i-set-title-permenantly.html)

unplugs[_3_]

How can I set the title permenantly
 
I'm doing a user Form and the data that get from the user form will b
transfer to the worksheet. Anyway, since it dun have any title for eac
column of cell, is quite messy looking... because it just transfer th
data to the first row and keep on going.

My question here is, how can we do so that the first row is alwaz th
title of the cells?

For example, I want to set the title of cell A1 = "Name", cell B1
"Age", cell C1 = "Gender"

How I can do so that I can permanently set the title? Is there any vb
code tat can do it?

Or is there any method to do so

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com