Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default using an input box to allow users type in the differnt fields name


Hi. I am quite new at VBA programming and would like some help to solv
this query of mine.

I have a raw datasheet and i wished to do a program to get an outpu
into another stylesheet using an input box to allow users type in the
different fields i have in my first column in my raw datasheet. Let sa
A,B,C,D,E. I hope somebody could help me with this.

something like this:

Regions District Count
A er 3
A rt 3
B vr 2
B ht 4
C ty 4
C ty 7
C yu 9
D oi 11
D oi 5
D we 23
E qe 5
E qe 2
E sd 3


Another query i have is, i hope to sum up some counts for differen
specifications. I noe using =sum() function could help. However,
would like to do a simple VBA program so that it will automaticall
update the sum for me in future when i have an update in variou
specifications. How can i do it? I hope somebody could help me wit
this too..

Thanks

--
ryl
-----------------------------------------------------------------------
ryll's Profile: http://www.excelforum.com/member.php...fo&userid=2860
View this thread: http://www.excelforum.com/showthread.php?threadid=48270

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clearing fields when differnt function selected Xman Excel Worksheet Functions 0 April 9th 10 04:46 PM
how do I set up an input calendar for users in excel MikeL Excel Discussion (Misc queries) 1 February 23rd 10 09:54 AM
How can I create a simple form where users can tab between fields DMAC Excel Worksheet Functions 1 June 24th 09 11:06 PM
Any ideas for making this graph type easy for other users? Del Cotter Charts and Charting in Excel 5 December 5th 07 12:47 PM
Alerting Users that Required Fields have not been Completed XLUser Excel Discussion (Misc queries) 6 July 13th 07 09:16 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"