Make Cell Look like Textbox

dude you're crazy

use Access forms. you can do this without a problem.

Access is Excel on Steroids

What I'm trying to do in Excel has already been done. This is nothing new. I'm just trying to learn this format technique for a better look.

The sample I attached is from an excel spreadsheet.

I know how to use Access, for this project it is over-kill.

Excel and Acess are really for quite different applications, and many people
use Excel when they should be using Access. Forms (they're called
UserForms) can be made in Excel, much like in Access. I think the OP was
trying to make a worksheet form (not a UserForm), and trying to get it to
look more like a UserForm.

One issue with using a sheet as a form is that many people don't know how to
change stuff in Excel cells. One has to know that anything one types will
replace the cell contents unless you double-click or F2 into Edit Mode. You
don't just click into the box and change whatever's there as with UserForms,
Access forms, boxes in web pages and many other interactive things.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

<[email protected]> wrote in message
news:[email protected]...
> dude you're crazy
>
> use Access forms. you can do this without a problem.
>
> Access is Excel on Steroids
>

Apparently you're using a worksheet to make a form. You can put extra rows
and columns between the cells that are to function as textboxes, to make
them separate. Then put borders around the cells that are to function as
textboxes. You'll want to control access to the extra (non textbox) cells
with sheet protection ("select unlocked cells" only). You can turn off the
worksheet gridlines (Tools - Options - View). You can also put real
textboxes on the sheet with the Forms toolbar, or the Controls Toolbox
toolbar. They can be linked to cells, which can be elsewhere, hidden or
whatever, so only the text boxes are visible.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"bjoeylouie" <[email protected]> wrote
in message news:[email protected]...
>
> I'd like to have a spreadsheet cell look like a textbox on a windows
> form. The textboxes will be perpendicular and adjacent to each other.
> No cells between cells.
>
> Essentially I'm trying to add padding to a the cell border. So each
> cell is separate and distinct like a textbox.
>
> For an example look at the 'sample spreadsheet '
> (http://tinyurl.com/7ptof) with the free xml 2003 add-in.
>
>
> Appreciate the assistance.
>
>
> --
> bjoeylouie
> ------------------------------------------------------------------------
> bjoeylouie's Profile:
> http://www.excelforum.com/member.php...o&userid=23819
> View this thread: http://www.excelforum.com/showthread...hreadid=377860
>

Access isn't overkill for anything.

Excel is a disease; and beancounters are the enemy.

My goal in life is to get Excel dorks fired-- to automate them out of a
job.

People that 'only know excel' in addition to some easy accounting
coursework--- those people should be roadkill...

Excel dorks somehow dont understand that they need to commit themselves
to numbers in order to get ahead.

Most Excel dorks i work with don't take numbers seriously.

Why in the heck is it overkill in Access?

I mean-- would you rather make the same XLS every week; or have it
AUTOMATED??